We help IT Professionals succeed at work.

Is there anyway to reset the lock out system with Access2007

rowenazone
rowenazone asked
on
Am new to Access 2007, so was trying things to see how to remove the main navigation and restrict access to normal users.  Unfortunately I was trying this on my main current database that I am working on by de-selecting all of the above, and didn't back it up first!!  But I now seem to have completely locked myself out as well from accessing anything on it other than the forms that come up, for some reason I thought I could just make a selection to unhide these options, but I have no selections at all.  I also have 2003 on my system, but it is also now not showing the unhide option within that so I cannot even reset in that version.  Is there anyway I can reset what I have done or do I have to go back to a 3day older database and redo the work done over the last 3 days
Comment
Watch Question

Most Valuable Expert 2012
Top Expert 2013

Commented:
Try pressing and holding down the Shift-Key while opening the database.

This will work, unless you have also disabled "special keys"

Commented:
You can also open a new database and import all the objects from your 'locked out' database.
Most Valuable Expert 2012
Top Expert 2013

Commented:
ie: hold down the shift-key and double-click on your database file (or open your database however you do it), while keeping the shift-key down.
Commented:
double click first then press and hold SHIFT
Most Valuable Expert 2012
Top Expert 2013

Commented:
I always start with the shift key held down (it does work as described), because if you press it too late it has no effect (my reflexes just aren't that quick any more :)  ) .

Author

Commented:
Thanks for that.  This was the only one that worked, knew about the shift key option, had tried that numerous times, it had only worked for me once before, must have been by luck I had pressed it afterwards!!  It DOESN'T work if you press the SHIFT key before hand it only works if you press it after selection, on my machine anyway, it seems it is very specific to machines as on the customers machine, it works on pressing it BEFORE.
Most Valuable Expert 2012
Top Expert 2013

Commented:
Strange - it must be machine dependent as you say.  I have never gotten it to work the other way.

Glad you've got it resolved.

Commented:
I'm glad you got the issue resolved too, although at minimum I think mbizup should have gotten a share of the points for suggesting the SHIFT solution.