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
: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
: > : Hi,
: > :
: > : I am using Access 2002 at the moment.
: > : --
: > : Cheers.
: > :
: > : Rodrick
: > :
: >
: >