Set Table Group Permisions thru ADO or ADOX or DAO

[vcwanabe]

Hi, I hope someone can help.

I'm currently trying to tranfer data from an Access DB to a SQL DB programatically. I have the App working fine, however I have to go into the Access DB/Security/Users and Group Permissions and give Admin read rights.

I want this process automated so the user will not have to jump thru hoops to transfer the Data.

If I can manually change the Admin User Permission for a specific table, I think I should be able to also do this thru the VB apps' code using DAO,ADO or ADOX.

Does anyone understand what I'm asking and know what I might try?

Thanks Heeps

 

[TomKane]

Hi,

If you're moving to SQL Server then there are stored procedures that come with the app that allow you to do variuos admin tasks - the thing to do would be to see if there is a stored procedure that can do what you want and then work towards executing it from your app. forum962 or forum183 might be worth a look.

Best of luck,
Tom

 

[vcwanabe]

Thanks for the response Tom.

However the permissions that need to be set are in the Access DB. The Table has no permissions set on it normally. I can open the table in Access and manually change the group and user permissions, then my data transfer app works. But as stated, I would like to automate the Permissions change in the VB app so the user will not have to open Access to change the Permissions.

Am I explaining my situation well enough?