Help!! Need to remove securtiy accidentally created in Access 2003

E

ed2brazil

I am a new user to Access (I use 2003 version) and I accidentally created a
securtiy setting I don't want. I use it on my home computer and was trying to
enable all macros and I accidentally went to Tools>Security>User-level
Security Wizard. As soon as the wizard opened up I realized it was not what I
wanted and I clicked finish (i probably should have clicked cancel). Then
another window popped up with a form or something. I didn't even look at that
one I just closed it. Two shortcuts were created on my desktop to the two mdb
files I had open at the moment I used the User-level Security Wizard. To
access those files now, I need to go through the shortcut on my desktop for a
logon screen to show up in access. I just click on OK with the password blank
and it allows me to access the file. If I try opening up access the regular
way and then try to open the files like I used to do it will not allow me
("You do not have the necessary permissions to use the xxx object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you.") Even if I am logged in through the desktop
shortcut, when I try to do a mail merge it won't allow me. Please help me
undo what I did.
 
E

ed2brazil

I figured it out. When I ran the security wizard, it created a backup of my
unsecure mdbs. It was in the same folder as my mdb, but it had a bak
extension - I just got rid of the secured files, renamed the backup files to
have an mdb extension, and I was fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top