multiple users

  • Thread starter Thread starter vking
  • Start date Start date
V

vking

I created a database so supervisors can enter performance
evaluations on-line. How can I create a multiple user
environment so they all can use the database
 
I created a database so supervisors can enter performance
evaluations on-line. How can I create a multiple user
environment so they all can use the database
Click to expand...

Access is intrinsically multiuser, out of the box. You have to make a
special effort to force it to exclusive.

Nevertheless, I would suggest "splitting" the database. This divides
the database into two .mdb files - a "backend" containing nothing but
the Tables, which is shared by all users; and a "frontend" containing
the Forms, Reports, Queries and so on, with links to the backend. Each
user gets their own copy of the frontend. There is a "Database
Splitter Wizard" under Tools... Database Utilities which will do this
for you.
 
Back
Top