Compacting Database - no read permission

[Guest]

Hi there

I have a database that i created that is used by several different users.

Every morning i compact the database and create a copy.

this morning i've come up with the error message

Record (s) cant be read;
no read permission on U:\carol\backup~1\ProspectVersion3.mdb

I have absolutely no idea whats happened or where to be with this one.

I'd be grateful for any help that anyone can offer.

xxx

 

[Douglas J. Steele]

What are the permissions on the folder where the MDB file exists? Are they
different than the permissions on the MDB file itself?

When you compact, a new file is created (usually named db1.mdb, unless a
file with that name already exists in the folder). Once the compact is
complete, the original file is deleted, and the new file is renamed to
whatever the original file was named. The fact that the new file is created
means that it will inherit the permissions of the folder.

If that's the problem you're encountering, you might be able to use the code
MichKa has at http://www.trigeminal.com/codes.asp?ItemID=25#25