multi-user DB

  • Thread starter Thread starter gordo
  • Start date Start date
G

gordo

I'm trying to design an Access DB (User.mdb) which will be
used by about 50 users. This DB should get data from a
central DB (Main.mdb). Main.mdb is updated with new data
each month. These 50 users just need to get into the
User.mdb and view reports based on data from Main.mdb.

Each of the users need to get a different cut of the data
from Main.mdb, and the amount of data that each user gets
can be as much as several thousand records. Also, the 50
users most likely will need to view their reports at the
same time.

What would be the recommended way to do this?
 
Most people will tell you that an MS Access\jet database is not the right tool to use when you anticipate 50 concurrent users. You might be able to get away with it in you case because your users are only reading data.

I strongly suggest that you consider using SQL Server 2000. You may want to use an Access Project (.adp) for your front-end. Starting with Access 2000, you use Access to quickly create forms, reports, etc for SQL Server.

Scott Shearer, MCSD, MCDBA
********msshearer@@@ hotmail.com*****

----- gordo wrote: -----

I'm trying to design an Access DB (User.mdb) which will be
used by about 50 users. This DB should get data from a
central DB (Main.mdb). Main.mdb is updated with new data
each month. These 50 users just need to get into the
User.mdb and view reports based on data from Main.mdb.

Each of the users need to get a different cut of the data
from Main.mdb, and the amount of data that each user gets
can be as much as several thousand records. Also, the 50
users most likely will need to view their reports at the
same time.

What would be the recommended way to do this?
 
Scott Shearer said:
Most people will tell you that an MS Access\jet database is not the right tool to use when you anticipate 50 concurrent users. You might be able to get away with it in you case because your users are only reading data.
Click to expand...

You're correct in that yes, the number of read only users doesn't
matter.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top