Locked out! User Level Security WIzard

[el zorro]

Oops. A co-worker was trying to help me figure something
our with my Access program. He opened the User Level
Security Wizard, and when we decided that was not what we
wanted, he clicked "Finish" instead of "Cancel."

Now I am told I don't have permission to open my own
program! I have no idea how to get in there and fix it
(can it be done?) But a new file with a .bak extension
has appeared on my drive. Is that the backup file created
by Mr. Wizard? Can I just remove the .bak extension and
type in .mdb to get my old program back?

 

[Joseph Meehan]

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Note: God really can get in as can some determined knowledgeable types,
but most mortals will have some serious difficulty.

You will need to log in as administrator. Since you did not set up a
password, it will be blank and you can keep that way. The problem is I
don't know what happens if you don't set up the administrator account. I am
hoping it makes one for you.

Remember even God saves (back ups).

 

['69 Camaro]

Hi.

But a new file with a .bak extension
has appeared on my drive. Is that the backup file created
by Mr. Wizard?
Yes.

Can I just remove the .bak extension and
type in .mdb to get my old program back?

That's the first step. You likely also need to rejoin the default
workgroup, depending upon which version of Access you are using. For
instructions, please see the tip "How to open databases and only be prompted
for User ID and password for the secure databases" on the following Web
page:

http://www.Access.QBuilt.com/html/security.html

In case you want to learn how to unsecure the secured database, please see
section 34, "How can I "de-secure" a database?" in the Security FAQ on the
following Web page:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)