Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 28th, 2004, 08:49 AM
Registered User
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default how far to push Access DB ?

i'm about to built a budget DB driven site for someone.
access is the cheapest option for me, as my host charges for mysql, plus i aint used it before!

they anticipate around 250 visitors per day.
would access on a dsn-less jet connection hold up?
how many consecutive users would it handle before it fell over.. ?

Old July 28th, 2004, 12:16 PM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

 Hi I have been told from microsoft the recommended record limit size is near 10,000 records...
Old July 31st, 2004, 05:41 PM
Friend of Wrox
Join Date: Sep 2003
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne

I'll take it from here-


In regards to your question about the issue with the number of consecutive users of an Access DB, the limit is 255 concurrent users.

Hope this answers your question.

Ben Horne
Madison Area Technical College - Truax
3550 Anderson Street
Madison, Wisconsin 53704-2599


"There are two kinds of people in the world: Those who claim to be Flash junkies and those who actually are Flash junkies"

Similar Threads
Thread Thread Starter Forum Replies Last Post
push to users dfeuerborn VB Databases Basics 2 August 29th, 2005 10:18 AM
Excel VBA - Access database push to users dfeuerborn Excel VBA 1 August 19th, 2005 02:50 AM
Converting Access DB to Online DB eyal8r Access 5 December 6th, 2004 05:22 AM
access db to sql server db mikersantiago Classic ASP Basics 4 November 16th, 2004 03:33 AM
Pull or Push? sureshvb Crystal Reports 0 August 23rd, 2004 01:13 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.