General discussion

Locked

Access 97 Security

By IreneCM ·
Have a database I inherited from someone who has left. When I try to open it I get a message " you do not have privileges to open this database contact the administrator or person who created this database." It doesn't ask for a password. Everyone that is supposed to have access to this database cannot open this file, I cannot copy the tables into another database, I cannot open a copy of the db on my drive. IT has no idea what or why I cannot open this file as I have permission, to the drive, the folder, the files. As far as I know there is no password on this file. How do I get the info out? or myself in? This is the only file on this drive that I cannot access

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Security

by Glen_McLeod In reply to Access 97 Security

The person that left has secured the database then deleted the mdw file that went with it. By removing then 'Admin' user as owner, you HAVE to have the .mdw file and log in through Access security. Trying to open a new .mdb file and import the objects uses the 'Admin' user which, in this case, no longer has any rights to the objects, and is denied permission.

Either get the file, usename and password from the 'someone whe has left' (not on good terms, I assume?), or you're going to have tosearch the web for something that will crack the security.

Glen

Collapse -

Access 97 Security

by timfox In reply to Access 97 Security

Some Access DBs allow a user to open the DB application through the backdoor with a shift key combination. As to how much you can do with the DB after this point is really up to the developer - so it might not help... :-(

What happens when you try openning the DB when you have the shift key depressed?

Collapse -

Access 97 Security

by IreneCM In reply to Access 97 Security

That was one of the first things I tried and I couldn't get that far. I just got the message immediately in Access without ever seeing the file. Thanks anyway.

Collapse -

Access 97 Security

by timfox In reply to Access 97 Security

Can you create a new database and create link tables that point to your secured database?

Side note - How big is the database file as a zip file?

Collapse -

Access 97 Security

by IreneCM In reply to Access 97 Security

No, I tried to do that first. I was shocked that I would probably have to code something in a blank database to draw those tables, etc in. Thank goodness I was able to contact the person who created this and she remembered from 3 years ago that I needed a shortcut to open it.

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums