Database is locked by user doing report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If one user is doing a report no body can enter data to the database. Is
there a way to prevent this from happening?
 
If one user is doing a report no body can enter data to the database. Is
there a way to prevent this from happening?
Click to expand...

Just make sure that nobody is opening the database Exclusive; check
the Tools... Options to make sure that the default open mode is
Shared, and that nobody is using /excl on a shortcut command line.

John W. Vinson[MVP]
 
Minnow said:
I am not using split database system.
Click to expand...

I would start there. Not only is it likely to eliminate this problem,
but is likely to avoid others and speed up the database.
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
Database locks after running report 8
Locking Out 2
"Could not update; currently locked." 4
Disable F11 key and lock database 2
Multiple users 3
cannot update error 2
Access Access Report Works on One Machine but not Another 3

Back
Top