How can I allow only 1 user at a time in an Access 2007 database?

  • Thread starter Arvin Meyer [MVP]
  • Start date
A

Arvin Meyer [MVP]

You can deny privileges to create and delete files on the server. That will
keep them from creating the LDB file.

Why do you only want 1 user at a time? If you split the database, as you
should for databases running on a server, each user runs the front-end from
their own workstation, linked to that data on the backend. Dozens of users
can share the database.
 
J

Jeff Boyce

I'm with the others responding to your post.

Why? What business need are you attempting to solve by limiting access to
your database to one person at a time?

--

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 pseudocode 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top