 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / May 2008You Don't have permission to run Macro
Hi, I have an Access database. When I try to run a macro in it, it givess me an error message "You Do not have permission to run XXXX". There is no security implemented on database. Please Help. Thanks in Advance.  SignatureCheers. Rodrick What version of Access? Access 2007, have you added the folder where the MDB or ACCDB exists to the Trusted Locations? Click on the Office Button, then follow the path through Access Options | Trust Center | Trust Center Settings SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Hi, > [quoted text clipped - 7 lines] > > Thanks in Advance. Hi, I am using Access 2002 at the moment. SignatureCheers. Rodrick > What version of Access? Access 2007, have you added the folder where the MDB > or ACCDB exists to the Trusted Locations? Click on the Office Button, then [quoted text clipped - 12 lines] > > > > Thanks in Advance. Have you given users permission to run the macro? Is the message saying you can't run 'the macro' or is it some other object (I'm thinking you have an action to run a query and it's the query they don't have permission on. SignatureJoan Wild Microsoft Access MVP : Hi, : : I am using Access 2002 at the moment. I have not given any security permission to macro, however, when I goto user and group permission. Open/Run is unchecked for object type: Macro. It is a stand alone database sitting on my system. If someone has given the permissions accidently then I am not aware of it. SignatureCheers. Rodrick > Have you given users permission to run the macro? Is the message saying you can't run 'the macro' or is it some other object (I'm thinking you have an action to run a query and it's the query they don't have permission on. > > : Hi, > : > : I am using Access 2002 at the moment. It sounds like someone played with security at some point (even if they cancelled part way through), and this macro was created with another workgroup file. Is it possible for you to recreate the macro? SignatureJoan Wild Microsoft Access MVP :I have not given any security permission to macro, however, when I goto user : and group permission. [quoted text clipped - 8 lines] : > : : > : I am using Access 2002 at the moment. Yes, I can create new macros. SignatureCheers. Rodrick > It sounds like someone played with security at some point (even if they cancelled part way through), and this macro was created with another workgroup file. > [quoted text clipped - 12 lines] > : > : > : > : I am using Access 2002 at the moment.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.