Need to Put anti Locking on a DB

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

Guest

I have a task to develop a simple DB to log Issues, these issues will be
looked at by possibly two people at the same time, how do I prevent
corruption of the DB and deadlock, and only one Person being allowed to
update a record, is it possible that some communication can be sent to the
uses to inform them that another person has the Record open for Edit.

What is the best way to configure this in ACCESS 2007, where in Access 2007
can I do this
 
Hi, If you create user, groups and permissions I assume you would not need to
be able to see who is on the db? by this I mean once set, no one except you
and anyone you allow can edit info Correct?
 
Hi again, Hopefully you have resolved your problem, if not split your db.
That will eliminate any problems with multiple users at the same time. Also,
if you don't, you should see a message pop up something like "db locked by
admin user" and an identifier of the name of the machine that is currently
editing your information.
 
Back
Top