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.