Locked out of Database

[April15Hater]

Well this is the second time this week I've managed to screw up my db file.

I have the FE secured via User Level and in the startup window I disabled everything. I also have it set to DisableBypassKey, so no shift on startup. I thought the startup form that I chose had the EnableByPassKey macro on it, but it wasn't. So now I can't enable it and I can't get into VB to undo anything(alt-f11 doesn't work). I'm kind of at a loss and don't even know where to start. Any ideas guys?

Thanks,

Joe

 

[jsv2002]

Tried ctrl+break?


EDIT:

Attached is a properties setter can't remember which MVP site I download it from but was created by Bill Mosca and allows you to set start up properties of a DB So thanks Bill and whoever's site I downed from.

good luck John

 

[Banana]

I'd probably try to open the database via code from another database:

Air-code and shortened for brevity:

Dim db As DAO.Database

Set db = DBEngine.OpenDatabase( blah blah <include your security credential here)

Set db.Properties("EnableByPassKey") = True

It's only good if you can actually log in at all. If you have no idea what your credentials are, then it's either breaking the .mdw or starting over.

You made a backup, right?

 

[boblarson]

Well, if you don't find a way today, I can email you the tool I have at home that should let you re-enable the bypass key. I don't have it with me here at work otherwise I could do it now.

 

[April15Hater]

jsv-

That's a really good little tool, and it worked!! Thanks so much man, you saved me hours of pain, lol!.

Bob-
Although I was able to get in with jsv's tool, I'd still like to have your tool just for another out. Would you mind sending that to me when you get a chance? I'll pm my email address

Thanks everyone!

Joe