Link to home
Start Free TrialLog in
Avatar of Sim1980
Sim1980

asked on

Microsoft Office Access - User does not have permission to perform this action

Hi all.

I have an Access 2003 ade file that has a form that creates logins for my Access form. I get the following error:

"User does not have permission to perform this action"

When it gets to this line of code in the VBA:

DoCmd.RunSQL "EXEC sp_grantlogin '" & WindowsID & "'"

Open in new window


WindowsID is a field on the form. I don't know why this is happening. The user has datareader and datawriter permissions in the database.

What is going on?

Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sim1980
Sim1980

ASKER

I've never had to do that. But I'll go ahead and do that and see.