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.
--
Cheers.

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rodrick" <(E-Mail Removed)> wrote in message
news:94598DB2-C089-4DF6-AED1-(E-Mail Removed)...
> 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.
> --
> Cheers.
>
> Rodrick

Hi,

I am using Access 2002 at the moment.
--
Cheers.

Rodrick


"Douglas J. Steele" wrote:

> 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
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Rodrick" <(E-Mail Removed)> wrote in message
> news:94598DB2-C089-4DF6-AED1-(E-Mail Removed)...
> > 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.
> > --
> > Cheers.
> >
> > 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.

--
Joan Wild
Microsoft Access MVP
"Rodrick" <(E-Mail Removed)> wrote in message news:12A794CD-478E-46E8-83F0-(E-Mail Removed)...
: Hi,
:
: I am using Access 2002 at the moment.
: --
: Cheers.
:
: Rodrick
:

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.
--
Cheers.

Rodrick


"Joan Wild" wrote:

> 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.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Rodrick" <(E-Mail Removed)> wrote in message news:12A794CD-478E-46E8-83F0-(E-Mail Removed)...
> : Hi,
> :
> : I am using Access 2002 at the moment.
> : --
> : Cheers.
> :
> : 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.

Is it possible for you to recreate the macro?

--
Joan Wild
Microsoft Access MVP
"Rodrick" <(E-Mail Removed)> wrote in message news:814FCF74-D9A9-4FDC-B022-(E-Mail Removed)...
: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.
: --
: Cheers.
:
: Rodrick
:
:
: "Joan Wild" wrote:
:
: > 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.
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > "Rodrick" <(E-Mail Removed)> wrote in message news:12A794CD-478E-46E8-83F0-(E-Mail Removed)...
: > : Hi,
: > :
: > : I am using Access 2002 at the moment.
: > : --
: > : Cheers.
: > :
: > : Rodrick
: > :
: >
: >

Yes, I can create new macros.
--
Cheers.

Rodrick


"Joan Wild" wrote:

> 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?
>
> --
> Joan Wild
> Microsoft Access MVP
> "Rodrick" <(E-Mail Removed)> wrote in message news:814FCF74-D9A9-4FDC-B022-(E-Mail Removed)...
> :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.
> : --
> : Cheers.
> :
> : Rodrick
> :
> :
> : "Joan Wild" wrote:
> :
> : > 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.
> : >
> : > --
> : > Joan Wild
> : > Microsoft Access MVP
> : > "Rodrick" <(E-Mail Removed)> wrote in message news:12A794CD-478E-46E8-83F0-(E-Mail Removed)...
> : > : Hi,
> : > :
> : > : I am using Access 2002 at the moment.
> : > : --
> : > : Cheers.
> : > :
> : > : Rodrick
> : > :
> : >
> : >
>