How many simultaneous users can access handle at one time?

[dkmidi]

Hi there,

I did some testing the other day where I and another person both opened the same table and began typing in information. I found that access was able to keep track of the sequence of our entries perfectly. Does anyone know how many people Access could allow for this type of updating or even just for information browsing/sorting purposes?

Thanks for any help!

Derek

 

[LittleSmudge]

It depends on many issues.

I've have 20-25 users all loading data into an Access database at the same time and the only problem was data access issues when the page level locking caught two adjacent records when users were updating/editing.


Other people will report problems in response times with three of four users - if the data handling and manipulation is intensive.


As an exercise to prove out a principle recently I created a database that stored a LongInt in a table.
A Form in a second database opened a recordset connection to the first db retrieved the value, then incremented it and closed down the link. The On_Timer event in the Form then repeated the evercise every millisecond.

I created many duplicates of the second database and set them all running.

It was quite obvious that only two of these databases could run at any one time without performance problems.


G LS

 

[MarcLodge]

According to the manual MS Access 2000 can handle up to 255 concurrent users of a database!

 

[dvannoy]

if you have more then 20 users...you would be better off using SQL server. I have a DB that I am in the process of converting to SQL server with a VB front end using ADO to connect. Access works fine in most cases, but if your users access the same records at the same time you will have problems.. also in a large multi-user environment, you will run into corrupt tables and forms. also you have to take into count how many records will be in your table..if you donot want to babysit your apps, use VB and SQL server..Much faster and can handle record locking much better..

Just my opinion..

 

[dkmidi]

Thanks Everyone for the info! Much appreciated.

dvannoy:

If I develop a VB fron end can I access and query information from an access DB without having the need for IIS or a server? Would you recommend this over using an ASP form to query? Plus can I forward a VB front end to other users over the network to query the Access database?

THanks!

 

[dvannoy]

If you want to keep your data in access then just use access 100%. Yes you can execute querys from VB. but I dont use VB with access so I am not to sure how.. I do know with using VB and Sql server you can execute Views and stored Procedures through a VB fron end.

Good Luck