Repair and Compact

[DJ_DEF_CON_1]

I am running Access 97 and am trying to repair and compact a database. I can repair it fine (Or so it says), but on compacting, I get the following message.

"Record(s) can't be read; no read permission on "My database"

Any ideas would be appreciated

 

[The_Doc_Man]

Someone secured your database and you aren't the owner or the administrator.

You cannot proceed until you are in one of those two roles for the DB.

If you can take ownership of the whole database, you have a chance to do what you want. If you know the administrator account and can log in as that account, you can do what you want. If neither, you are stuck.

After re-reading, it hit me that the EXTERNAL file permissions could also be the problem. If you don't have permission to write to the folder in which the database exists, you cannot compress it because compression involves making a COPY of the DB (which implies writing) and then deleting the old version and renaming the new one to the name held by the old one.

Is there more than one LOGIN account on that system? That is the only way I can imagine that the permissions would be wrong.