Auto compact not working in access 2002

[jm7]

I have just come across a rather odd error message:
Over a network I have an Access 2002 front end (xx.mdb) and an Access 97
backend.

if I have the front end Auto compact on close, I get this message when I
quit the application:
Could not use "c:\xx\xx.mdb"; file already in use

Sometimes when I double click on the xx.mdb file - I also get an error that
the file may be corrupt but then it starts fineanyway after I click OK.

Thanks in advance

 

[Douglas J. Steele]

The implication is that someone else is using the front-end when you're
exiting it.

You shouldn't be sharing front-ends. Each user should have his/her own copy
of the front-end, preferably on their hard drive. If you're concerned about
propagating changes to the front-end to all users, see the free Auto FE
Updater Tony Toews has at http://www.granite.ab.ca/access/autofe.htm

One of the reasons for not sharing front-ends is that sharing them
significantly increases the possibility corruption. The other message you
mention is possibly the first sign of that.