Multiple users

  • Thread starter Thread starter Stryder09
  • Start date Start date
S

Stryder09

I have a database created that will have 5 users in the plant at any given
time. I was wondering if there is a way to have the database locked by a
user in it that would prevent the other 4 from going in until vacated by that
user.

Thanks for any help given.
 
While possible (open in "exclusive" mode), why? Is it likely that more than
one user would be trying to use exactly the same data simultaneously?

What "problem" are you trying to solve with this "solution"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Because it is one table that they are all populating it is possible that
information might be entered on two different stations at the same time. I
also have a problem which I am trying to correct with people leaving the
database open on their computer when they are not using it, having only one
user in at a time would end these problems because when they try to log in it
could say program in use by...... try again later. Then if they try later
and get the same message they can call and request them to exit the program.

Thanks for your responce Jeff.
 
If that one table into which they might enter data (via a form, right?!) is
being 'locked', you could modify how your form/queries use that table to
allow more than one user at a time.

There are routines available (search on-line) that will shut down an open
copy of an application if there's been no activity for ## (you fill in the
amount) minutes.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top