Database Open Exclusive

  • Thread starter Stephen sjw_ost
  • Start date
S

Stephen sjw_ost

Hello, thanks for everyones help in the past. I've got another question for ya.

Is there a way to ensure a frontend DB is NOT opened in exclusive mode
except by me or another authorized admin? The permissions part I beleive I
have, it's the setting of "Open Exclusive" vs "Open" I am needing help with.
Side note; I do not want it to be opened read-only either. Just "Open" by a
user.

What I am looking for, if it can be done, is a user opens my FE DB and can
use it as intended but I can come in and "Open Exclusive", if needs be.
Kind of like having an Excel file in shared mode. One user can make a change
to the Excel file and save, once the other users click save on their own PC
they can see the update or change that was made.
Can access do this? Can multiple users have the DB "Open", I come in and
"Open Exclusive", make a change, save and the other users see the change via
an update timer or update button?
 

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