Restrict multiple users in database

R

R Ormerod

Is it possible to lock access to a database if a user is already in the file
(like Excel read only)?

I have Access 2000.
 
R

Rick B

One of the options (Tools/Options/Advanced/"Default open mode") let's you
specify if the database should open as shared, or exclusive.
 

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

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Managing multiple jobs in a fabrication shop 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Crating User Form to Add Names 1
Embed the same Excel multiple times 0
Help with security setup 2
Autonumber field in Excel that behaves the same as Access 0
Protecting Word 2019 document 0

Top