Compacting error

[greaseman]

We were compacting (or trying to) an Access 97 database and got the following error:

"Record(s) can't be read: no read permission on xyz.mdb."

The error occurred on a database that we know we have complete permissions on, since we have done repairs and compacts to this very same database for ages.

If anyone can help shed some light on this error, we would love to hear from you. The Microsoft help file is not too helpful - all it said was basically that we don't have the proper levels of permissions to do a compact.

Looking forward to your responses!!!

 

[GumbyD]

It sounds to me like the database is corrupted. Can you run a repair on it?

GumbyD

 

[greaseman]

We did do a repair on it before trying to do a compact. The repair ran OK. That's what's confusing us.

Thanks for your reply!

 

[GumbyD]

If the error comes up right away it may be a permissions issue; however, if it comes up after the compact process seems to be complete than the file is corrupted. Your best bet might be to go to a back up copy and redo any data entry that was lost. You might also try creating another database shell and importing all of the objects from your existing database into the new shell.

Good Luck

GumbyD