Limit database to one user at a time

  • Thread starter Thread starter RRS
  • Start date Start date
R

RRS

I am currently running a database in Access 2002 that has
several make table queries. It needs to be accessible to
a large group of people but I only want one person to be
able to use it at a time. How do I set it up to keep more
than one person using it at a time?
 
If you must, the Default Open Mode can be changed by selecting Tools|Options
.... Advanced from the main Access menu.

It occurs to me that you may need to do this because you have an application
which is deployed as a single MDB file on a server, with each user opening
the same MDB file. In this deployment scheme, Make Table queries will be a
real problem. If the Make Table queries are there to support Reports or
other user 'information-gathering' processes, have you considered splitting
your application into a Front-End/Back-End deployment?

In this deployment scheme, the Front-End contains all Queries, Forms,
Reports, Macros and Modules and the Back-End contains all Shared Data
Tables. Each user opens/runs a Front-End which is located on his or her
own computer; and, in the case of Make Table queries, the tables are written
to the user's copy of the Front-End database, not to the Back-End.

Here is more information:

http://www.granite.ab.ca/access/splitapp.htm
 
Back
Top