Lock Form to allow only one user at a time

[Jeff E via AccessMonster.com]

I have a muli-user database on the server. The database is in one MDB file
(it isn't split into FE/BE). It is sercured so that a user has to log in to
the database.

When a user opens a specific form, I don't want others to open it but rather
get a msgbox stating that USERNAME is already in it.

I tried to record lock but setting the property to Edit record doesn't lock
the form from being open and it creates(the way the user interacts with the
form) a duplicate record (the database won't allow it, it only tells the
second user that the entry he just did is not going to be saved). Setting it
to ALL Records, locks the whole table out and subsequently other users can't
do other things in the database.

What I am locking for is not a record lock but a form lock.

Please help.

 

[Guest]

Hi,
your database HAS TO be split into FE and BE. This will prevent corruption
and many other issues.
HTH
Good luck

 

[Jeff E via AccessMonster.com]

Thank you and I know that. I am in the process of doing just that. But I am
still interested, in the meantime, to do as I posted above. Is it possible?

Hi,
your database HAS TO be split into FE and BE. This will prevent corruption
and many other issues.
HTH
Good luck

I have a muli-user database on the server. The database is in one MDB file
(it isn't split into FE/BE). It is sercured so that a user has to log in to

[quoted text clipped - 13 lines]

Please help.