how many clients can access 2003 haddle?

[Guest]

I was wondering how many clients in a network Access 2003 can handdle. I have
a network with Windows 2000 server and around 20 clients. If anybody knows
please let me know. Thank you

 

[Douglas J. Steele]

It's not really possible to give a definitive answer, as there are many
variables involved. Network speed, database design, mix of users updating
vs. only reading are just three.

I've read lots of reports of people being able to support in excess of 20
clients, but I've also read of people having problems supporting 3 clients.

One thing to be sure of, though, is that you split your application into a
front end (containing the queries, forms, reports, macros and modules),
linked to a back end (containing the tables).

Only the back end should be on the server. Each user should have his/her own
copy of the front end, preferably on their hard drive.