Database is locked by user doing report

M

Minnow

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

John Vinson

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]
 
M

Minnow

I am not using split database system.

I work on the database directly while other users are linked to the tables
they need to work on.

I am the one doing the report. Once I do the report, the database is locked
and other users can do nothing. The database is shared.
 
J

John Vinson

I am the one doing the report. Once I do the report, the database is locked
and other users can do nothing. The database is shared.
Click to expand...

Split the database.

If you open any object in design view, that locks out all users from
design view for any other object.

This won't affect just *running* a report, but if you're manually
changing the criteria, you'll lock everyone else out from doing the
same.

A split database prevents this problem (and improves performance,
reduces database bloat, and makes corruption less likely).

John W. Vinson[MVP]
 
Top