Access User Numbers 2

[matrixindicator]

Access version 2007. How many users can use the same database in an Intranet without performance problems ? Probably 20 to 30 users will use the database. How does this work. Do you have one application accessed by all the users simultaneous ? Or do you replicate the data ?

 

[randy700]

Split your database, placing the BackEnd (tables) in a network folder. Provide copies of the FrontEnd (everything else plus links to the tables) to each user. 20 to 30 users should be no problem.


Randy

 

[MajP]

Microsoft Access can technically allow 255 connections for each database. However, this is a theoretical limit and cannot be attained in an organization. In reality, the number of connections or users that an Access database can support is dictated by how well the application was designed and implemented.
For example, a professionally designed and well-tuned Access application can support up to 20 concurrent users who are updating data with good performance. Databases that are used largely for running read-only reports can scale up to about 100 users.
Unfortunately, few Access databases are well-designed and implemented with best practices. This is because most Access databases are created by beginners or power users who do not have the experience or knowledge to create professional applications. They are built over time, and new features and data models are added as needed. The result is that many solutions don’t reliably support more than a few users.

 

[boblarson]

And if you want a quick way to update the user's frontend when you have made changes to a master frontend, you can use something like my free frontend auto update enabling tool located here:

http://www.btabdevelopment.com/ts/freetools

or Tony Toews' auto updater:

http://www.autofeupdater.com/

or there are others out there as well. There are also other methods you could use like using a batch file that the user clicks which copies the latest version to their computer, overwriting the last one copied, etc.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com