multiple user opening the same database at the same time

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

Guest

I'm a newbie to access and I need your help. How do I make the db to behave
in the following manner:

1. the first person that opens the db has exclusive rights to it.
2. other ppl that opens the db while the 1st person still has it open on
his/her computer will have read only access.

Is this possible?
 
Michelle Lee said:
I'm a newbie to access and I need your help. How do I make the db to
behave
in the following manner:

1. the first person that opens the db has exclusive rights to it.
2. other ppl that opens the db while the 1st person still has it open on
his/her computer will have read only access.

Is this possible?

If what you want is for user 1 to have read/write permissions to the data
and others read-only then you would need to invoke user level security
(ULS). If you're a newbie then be prepared for a baptism of fire, ULS can
be a pain for the inexperienced. My website has a link to the MS Access ULS
FAQ - you must read and understand this first and miss out *none* of the
steps - and there's also my step-by-step example to try. Please be sure to
back your files up first, it is very easy to lock yourself out.

Regards,
Keith.
www.keithwilby.com
 
Further to Keith's reply, ULS is the way to go if you want one
specific user to have read/write permission, and all others to have
read-only permission. As Keith said, the learning curve is steep...

If, on the other hand, you want the FIRST user to have read/write
permission (regardless of their identity) and all SUBSEQUENT users to
have read-only permission (your question implies this is your
requirement), then I think you are out of luck. You would need to
program this function into your application - perhaps by toggling OFF
the Edit property of your form. Anybody using the data from outside
your application would bypass this level of "security" and it would be
daunting to program such a feature.




I'm a newbie to access and I need your help. How do I make the db to behave
in the following manner:

1. the first person that opens the db has exclusive rights to it.
2. other ppl that opens the db while the 1st person still has it open on
his/her computer will have read only access.

Is this possible?


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Michelle said:
1. the first person that opens the db has exclusive rights to it.
2. other ppl that opens the db while the 1st person still has it open
on his/her computer will have read only access.

In addition, the question I have is why? Access is designed for multiple
users.
 
Back
Top