G
Gordon
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?
Gordon
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?
Gordon