Access DB Lock Out

[ETCallHome]

Hi,

I have not been here for sometime now, but just had a blond moment and locked myself out of my database. I know there must be a way to get back into the DB with some programming code in another database, and if anyone can help me with the code I would really appreciate it.

What Happen? - I created a login form, where a user enters the login details. It was working fine and I loaded the login form as the form to open when access starts. Each time I open the DB I can see access 2007 popping up before the login form shows, also the background appears. I was trying to get rid of the background and the access 2007 start screen. I just wanted the login form to show. I then changed the following controls:

Allow Add... = No
Allow Del... = No
Allow Edits = No
Allow Filters = No
Data Entry = No

I saved the form and THEN...

When I started the DB, it do not do the required results and it would not allow me to enter the user details to login... all this said, I cannot access the db to change.

SOmetime back I result some DAO process where you can access another database and not the current one. I would like to do similar code to reset the password on the useraccess table so when I start my data base it will access a blank password..



Any Help is much appreciated.

Regards
Earl

[RuralGuy]

Can you open the db while holding down a <SHIFT> key?

[ETCallHome]

Thanks... It Worked. I still have so much to learn. I have been creating a developers userid and then using code to determine the access level, if developer, then Allow ToolBars, statusbar, etc. Otherwise only show the form and let the users do their thing and loggoff when they are done.

[RuralGuy]

That's great! Thanks for posting back with your success.