|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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.
|
|
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.
|
|
|