Compacting Access database

[Luis]

Hello.

I have several access 2003 databases that are placed on a network Fileshare.
All of these databases have "Compact on Close" option selected.
When i close the database, the compacting process starts, the db1.mdb
temporary db is created, but when the process ends this temporary db isn't
deleted and the size of the original database remains the same.
When i do this operation on the local disk, this doesn't happen.

Can anyone give me a hint on this issue?

Thanks

Luis

 

[Jerry Whittle]

First off do yourself a favor and turn Compact on Close off. Manually compact
once a month or so. You are just asking for a corrupt database.

Something is stopping the Compact and Repair process. As you can get it to
work on a local machine, we can thankfully rule out that the database file
has a problem.

All the users for those databases need Read, Write, Create, and Delete
privileges for those database files AND the folders that they are in. Most
likely not being able to delete the original, uncompacted database file is
stopping then new, improved DB1.mdb file from being renamed to the original
file name.

 

[Gordon Clark]

+1 on Jerry's response. Had a similar situation with an inherited DB. The
Users lacked the privileges to Read/Write/Create/Delete to the shared file
folders - resulting in DB1.mdb to DB100.mdb of compacted files that were
never written back as the orginating filename.

Once fixed, was never an issue again.

Gordon