Is it possible in access to modify user permissions with SQL?
R Rob.Mills Registered User. Local time Today, 01:29 Joined Aug 29, 2002 Messages 871 Jan 16, 2006 #1 Is it possible in access to modify user permissions with SQL?
P Pat Hartman Super Moderator Staff member Local time Today, 01:29 Joined Feb 19, 2002 Messages 43,371 Jan 16, 2006 #2 No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model.
No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model.
R Rob.Mills Registered User. Local time Today, 01:29 Joined Aug 29, 2002 Messages 871 Jan 16, 2006 #3 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.
P Pat Hartman Super Moderator Staff member Local time Today, 01:29 Joined Feb 19, 2002 Messages 43,371 Jan 17, 2006 #4 I assumed you were talking about securing the Access object model. My statement wasn't clear. Yes, SQL includes the ability to use queries to modify table security.
I assumed you were talking about securing the Access object model. My statement wasn't clear. Yes, SQL includes the ability to use queries to modify table security.
