Is there anyway to reset the lock out system with Access2007

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
rowenazoneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

This will work, unless you have also disabled "special keys"
0
kmslogicCommented:
You can also open a new database and import all the objects from your 'locked out' database.
0
mbizupCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

kmslogicCommented:
double click first then press and hold SHIFT
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
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 :)  ) .
0
rowenazoneAuthor 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.
0
mbizupCommented:
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.
0
kmslogicCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.