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:
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.
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 & "'"
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER