Question HELP!!!!! I've locked myself out of my database (1 Viewer)

[Sharkiness]

HI Guys,

I have made a serious mistake.

I used the code in this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=51479

To disable / enable shift key override.

As explained I set the Bypasskeyon function on my database logo.

Only I used the doubleclick function incase anyone thought to try clicking the logo.

I also made the drastic mistake of removing all startup options.

Now I cannot get into the background of the database at all.

Can anyone help? Also can anyone tell me why the double click bypasskeyon will not re-enable the shift key option.

 

[NigelShaw]

Hi,

RuralGuy posted a tool to connect to another db ( i.e. your locked one ) and reset the property.

also heres a tip that i do,

in the folder local to the database, i place a text file called say AccessDb.txt. i have a routine that checks for this on opening. if it is there, do not set property. If it is not there, set the property. The beauty of this is when you get into a situation where you lock yourself our database, put the text file in and the routine will see it and unset the property for you. Simples - eek!

if you can wait until tonight, i'll post it otheriwse, i posted it here a while ago. Search through my posts


Nidge

 

[Sharkiness]

Hi Nigel,

Thankfully i got the answer from another forum but i thought i'd best share as it was quite easy.

Open access without opening a database
Press Alt+11 to open VBA Window
Go back to Access Window and open the database

Within the VBA window press Ctrl+G so the 'immediate' window is in view


paste:

1. Call CurrentDB.Properties.Delete("AllowBypassKey")

You should then be able to close the database and open on shift key.

The mistake i made which i felt like kicking myself was I set both the Macros functions to set to BypassKey(False).

I would like to post thanks to NeoPa who provided this help in another forum and
haltonbj who thought of the call procedure in the immediate window.