Software

Ask something
Discussion Locked

Access 97 Security

0 helpful
5 replies

by irenecm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

5 replies

by glen_mcleod

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

by timfox

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?

by irenecm

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.

by timfox

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?

by irenecm

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.

This discussion is closed to new replies.