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

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

 

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

 

[Keith Wilby]

That's a bit like removing all but one of the seats on a bus!