RE: Need to Put anti Locking on a DB

microsoft.public.access.security

28 Sep 2007 8:19 PM

Mark

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.

--
Mark N

Show quote

"AccessHar" wrote:

> 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