Locked Myself out but do have password

[DaOtH]

All,

When rebuilding my database code i accidentally closed my database.

Unfortunately, i was just changing the enable / disable shift option. Result is, i locked myself out. I removed the procedure that enables the shift-key but didn't yet put in another one.

What i could do is create a new Access database and simply import everything in it. Unfortunately the VB code is protected with a password so it won't import the modules.

I do have the password i set on the VB code.

Anybody any idea how to solve this, or am i now forced to go back to my latest backup and redo today's work.

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[oharab]

Go to my website & get the file Lock&Unlock.zip
it contains a file that will lock or unlock external files. Run it and it will ask you for a file, choose your locked file and presto!!

HTH

B ----------------------------------------
Ben O'Hara
Home: bpo@SickOfSpam.RobotParade.co.uk
Work: bo104@SickOfSpam.westyorkshire.pnn.police.uk
(in case you've not worked it out get rid of Sick Of Spam to mail me!)
Web:

http://www.RobotParade.co.uk

----------------------------------------

 

[DaOtH]

Wow...

Resolved the issue myself already, but that's an easy one.

Simply changed the AllowBypassKey property using another database.

Thought disabling the shift-key was reasonably safe but apparently it isn't really.

Anybody any idea how to avoid changes to the properties from outside the database? "In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963