R Rob.Mills Registered User. Local time Yesterday, 22:28 Joined Aug 29, 2002 Messages 871 Jan 16, 2006 #1 Is it possible in access to modify user permissions with SQL?
R Rob.Mills Registered User. Local time Yesterday, 22:28 Joined Aug 29, 2002 Messages 871 Jan 16, 2006 #2 Pat Hartman said: No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model. Click to expand... Actually, I found out since I created this thread, that you can but you have to execute the sql through ADO. Why, I don't know, but it did work.
Pat Hartman said: No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model. Click to expand... Actually, I found out since I created this thread, that you can but you have to execute the sql through ADO. Why, I don't know, but it did work.
