Lost permission to open Access 2003 DB

[simonalle]

I have a user who cannot open their DB. They created the DB in Access 2000(or earlier), and have successfully used it when we migrated to 2003. Their user account was deleted accidentally and their new account cannot open the DB. I restored the system.mdw file from backup into their new profile, and they have Windows security permission to the DB. Access gives the error "Insufficient permission" when they attempt to open the DB. I think the problem centers on the workgroup information file (MDW). I tried recreating the system.mdw, but the DB was started in an older version of Access and migrated to 2003--no joy.

Any ideas accepted!

 

[lameid]

Ouch...

My first thought is that the workgoup they have does not have permission to open the database exclusively. This is necessary to convert the database or open an earlier version (I'm assuming that the old version was opened but never converted). If this is the case you MAY be able to get into the database by using an earlier version of Access, assuming it has permission. If it does, you can import evertything into a new database file, effectively stripping permissions. Then the new copy should convert just fine. The assumption here is that you have Read data and read design at some level in the earlier version of Access... This means the backed up workgroup file using the new version of Access.

My second thought is that your user may have created his own workgroup and you need to restore that .mdw and join it with the workgroup administrator.

I hope one of those two ideas helps.