why is backend opened running a query?

[Guest]

We have a split database. There is a front end and back end. We created
this because many people share the database and we import into the back end
from a software product called monarch that requires the database not be
opened when importing. But when you open the front-end and run a query, the
back end is locked and is looks opened but in reality not thus not allowing
someone else to import data.

What can we do?

 

[Douglas J. Steele]

Does Monarch use a Jet database (i.e. an MDB file), or something else?

If it's a Jet database, Monarch is probably looking in the locking file (the
LDB file) that gets created whenever anyone connects to the database. You'd
have to take it up with them as to why they need exclusive access.

 

[Bill Mosca, MS Access MVP]

The query running in the front end is working on data in the back end. That
means an LDB file must open to handle record locking.

If you open Windows Explorer and locate your BE folder you can watch the LDB
file show up when the query starts and disappear when the query closes
(provided there are no forms or reports open in the front end.