Access 97 will not compact

[James D Carroll]

I have an Access DB on the order of 125 megs sitting on the network and it
simply refuses to compact. It is the backend to an Access front end, but
I've even tried on Saturday afternoon when I KNOW there's no one else
hitting the database. It gets about 50 percent through the process then
says I don't have the rights to complete the task.

Any ideas?


TIA!!

 

[SteveD]

How about copying the database to your local drive, do the
compact and copy back to the network location.

This could be set-up in a different database that will do
this for you.

HTH
SteveD

 

[Van T. Dinh]

Do you have permission to Create (files) in the directory where the file
resides?

The reason is that Access actually compacts into a *new* database using the
default name dbX.mdb. Upon completion, Access deletes the existing file and
rename dbX.mdb to the old file name. Thus, you need Create permission on
the directory.