Error message when closing Front-End

  • Thread starter Thread starter Denis
  • Start date Start date
D

Denis

Sorry folks, I wanted to post this in
the 'microsoft.public.access' forum, but I keep getting
a "Newsgroup not available" message.

------------------------------------

We have the following front end/back end databases:

Back End: 'N:\daebm\daebm2\AF9000_Plus\Restore10Dec02
\MAPRegister.mdb'
Front End: 'N:\daebm\daebm2\AF9000_Plus\Restore10Dec02
\MAPRegister_Interface.mdb'

We get the following (annoying) message every time we
close the Front End:

"The Microsoft Jet database engine cannot open the
file 'N:\daebm\daebm2\AF9000_Plus\Restore10Dec02\db1.mdb'.
It is already opened exclusively by another user, or you
need permission to view its data. "


I don't understand why we get this message nor how to
resolve it. I have done the following in an attempt to
resolve this:

- First, I suspect that at some time, 'db1.mdb'
might have been created during a problem while compacting
a database. Nevertheless, it does not exist in the stated
folder;
- I have checked and (just in case) re-established
the paths to each linked table, using the Linked Table
Manager; and
- I have checked the MsysObjects table for instances
of 'db1.mdb' to no avail.

I appreciate your time and any assistance

Thank you

Denis
 
Do you have Compact on Close selected (on the General tab under Tools |
Options)? If so, see whether turning it off makes the error message go away.

If the message does go away, what permissions do your users have on the
folder?

For what it's worth, it's generally not recommended having the front-end on
the server. Having a copy on the hard drive reduces the amount of network
traffic.
 
Back
Top