Multi Copy Database, Limit form to 1 user

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

Guest

I have a multi copy database with a BE and I want a particular form to be
open by one user only at a time. Is there a way?
 
Access will not give this to you, so you would need to create a table where
you record who currently has the form open. You will need to append a record
there in the form's Open event, and remove it in the form's Close event. If
there is a record in the table, cancel the Open event to prevent another
user opening the form as well.

You will also need to provide some way to clean up in case a user crashes
with the form open. Otherwise your application would never let anyone into
the form again.

You have not told us your reasons for wanting to build the app this way, but
my guess is that there is a better way to solve whatever issue you are
attempting to avoid.
 
This is a inventory database where there are 4 people entering orders. It
auto numbers then the user enters a job # and clicks a macro to save that
Inv. # quickly. But still they are getting each others entries on their
invoices. I don't want to have this be a one user database so that all the
functions cannot be utalized at once, just the order entry. Is there a
better solution?
 
If you are using the AutoNumber, Access assigns it at the time someone
begins to enter a record. Even if they abort the entry, the number is
considered assigned and Access won't reuse it. That works fine with multiple
users who have the form open at once.
 
Back
Top