I have descended into Access HELL. I have a small database with an AutoExec macro. I got this annoying message every time I opened the database telling me that a macro was tyign to run, AutoExec. Since that was my desired intent I tried to fix it. Unfortunately I ran the Security Wizard. At the time I had only one user on the computer, USER, which had Admin authority. My AutoExec macro runs a query. Now I get a security message telling me that I don't have privileges to run the macro. When I go into Security/Assign User privileges it tells me tat I don't have the authority to do this.
Ideally I would like to be able to set the authorities by users. As a second option I would like to delete the changes made by the Security Wizard. Has anyone had this problem and successfully reversed it? Thanx George
