Macro's not working on the user machine but works on dbo machine

[dwight1]

Hi,

I have an adp project. I have macros to maximize and also to run all the append queries that use stored procedures on open command.

It runs great on my machine being dbo/sys administrator, but complains on the user machine. It is not able to run the append macros.

I have given users right to datawrite and dataread. I had also given rights to execute storedprocedures.

Can any one tell me what rights must also be given to users to run the program?

Thank you

Rishy Singh

 

[dwight1]

Got it. I did not keep dbo.appendqueryname.

Now it works.

Thanks