how many users can access the database at the same time?

[wshs]

just curious. in a network, how many people can access the database?

 

[Remou]

Have you seen:
MS Access limitations
thread181-538057

 

[dhookom]

I believe the specifications suggest 255. This is too high of a number for almost all Access databases that I have seen. A more realistic number of simultaneous users would depend on how they are using the application. If they are only reporting from the database then the number could be dozens. However, if tables are being written to and the tables aren't properly normalized the limit could be less than a dozen.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Ed2020]

It depends a lot on the design of the database and what it is being used for.

I find unbound forms to be better in situations where there will be lots of users entering/editing data.

As Duane said correct normalisation will make a difference.

Splitting the database into a frontend/backend and storing regularly accessed standing data in the frontend tables can be a useful technique.

One of my systems currently has over 100 users adding, amending and searching on data with no performance issues at all.

Ed Metcalfe.

Please do not feed the trolls.....