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?

 

['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.)