Locking records in a shared enviorment

  • Thread starter Thread starter David Ehrenreich
  • Start date Start date
D

David Ehrenreich

Is there a was to stop a user from opening a record if it
is already open elsewhere. I was think of some sort of vb
expression that would notify the user that the record is
locked try again later. I am familiar with default record
locking, but it did not work how I would like it. This is
how I have the db setup there is one db file with just the
tables then there are seperate files that have the forms
in them. These Db's have the tables liked to them.

Thank you
David Ehrenreich
 
Hi,


Lock all the records (form property).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top