Locked out of my database

A

abiba

created a db, and in the process of setting up security, i locked myself off
the db. Is there anyway i can gain access to the database?

thx
 
J

Joan Wild

It all depends on the version, and what you did. If you ran the security
wizard in a recent version, then the wizard created a backup of your mdb.
Look in the folder where the mdb file is located, and see if there is a file
with the same name, but a bak extension. If you find it, you just need to
rename it to have a mdb extension.

Some versions may have made your secure workgroup file (mdw), the default
one to use for all sessions of Access. The simplest thing to do, is to use
Start, Search and search all files/folders (including system folders) for
*.mdw. Rename every file that it finds e.g.. system.mdw to system1.mdw.
Now open Access and then open your renamed file from paragraph 1 above.

If this doesn't work, then post back with the version, and what you did to
'set up security'.
 
T

Tom van Stiphout

On Wed, 6 Aug 2008 09:16:02 -0700, abiba

Simplest way is to restore a backup. You DID create a backup before
going down this path, didn't you?

Beyond that, your best bet is to hire a competent developer that can
recover the database based on the premise that if you just
click-click-click applied securitly, you probably missed a few
critical steps. The Access Security FAQ mentions all of them. You
should have downloaded, studied, and fully understood it before
embarking on this path. Unfortunately MSFT doesn't make that very
clear in their UI.

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top