Locked out of my database

[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

 

[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'.

 

[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