Close and get new db1 file

[Guest]

Sometimes, when I close an Access file, I will get a message about unable to
save. The system will then save the file but will name it db1.mdb. One of
my users is experiencing this and claims that some data was lost. What is
happening and what can I do about it?. Access 2000 on w2000. I auto
compress on close.

 

[John Vinson]

Sometimes, when I close an Access file, I will get a message about unable to
save. The system will then save the file but will name it db1.mdb. One of
my users is experiencing this and claims that some data was lost. What is
happening and what can I do about it?. Access 2000 on w2000. I auto
compress on close.

The automatic Compact creates a new database named db1.mdb; copies all
objects from the current database into it; then deletes the current
database and renames db1.mdb.

If a user is running Access but does not have create, edit, and delete
privileges on the folder containing the database you'll get this type
of problem. If another user has the database open it *should* simply
close without compacting, but there might be a timing problem causing
it to fail to do so.

Check the users' privileges. That's the most likely problem.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps