Locking records in a shared enviorment

[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

 

[Michel Walsh]

Hi,


Lock all the records (form property).


Hoping it may help,
Vanderghast, Access MVP