Multiple Users at same time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've set up several user accounts with different ids and passwords.
Supervisors should be able to access a form to input employee data. I, as
the administrator, would like to be free to be in the database at the same
time, performing various tasks.

Currently, if my assistant is in the database, I can't make any design
changes to reports, forms, etc. Is there a way to set up security so that I
can make changes when someone else has the database open (provided the other
user is not actually in the form or report I'm trying to change)?

Or should I have tried replication? I'm nervous about that b/c I've read
you can't replicate a password-protected database.

Thank you! - Jenny
 
You can't change the design of those items unless you have exclusive
permission to the database.

If more than one user is using the file at a time, you should split the
database. You should have a backend that lives in a shared location that
contains all the data (the tables) and a separate front-end file that
contains the user objects (forms, queries, reports) and links to the tables.
Each user should have their own copy of the front-end on their PC. You
should keep a master copy of it that you use to make changes to the objects.
Then, you can distribute fresh versions to the users. In this scenario, you
will not be able to change the structure of the tables if anyone is in the
database. Everyone would need to get out to change the tables.
 
To add to Rick's reply, do not use replication. Replication is meant only
for data (not forms/reports...)
 
Thank you for your responses. The "fix" seems more advanced than perhaps my
current skill set...but at least I know that replication is not the answer
and that it's not as simple as anticipated!
 
Back
Top