Temporarily change permissions via VBA

[nickjar2]

I am quite stuck on this one. I have a secured db where certain users are unable to delete records from a certain table.
Under specific circumstances, I need my code to assign a user with delete privileges, delete a record, and then remove the delete rights away from the user.
I have tried DAO and ADO and ADOX. Here is some code i found in help reagrding ado and adox:

cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Open "data source=" & CurrentProject.Path & "\gl5-tempV1.2e.mdb;" & _
"jet oledb:system database=" & CurrentProject.Path & "\NL_Gl5.mdw"

and i get 'Not valid account name or path'

Any ideas?? Cheers! Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[BobLoblaws]

This might be of some use to you.

http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForAccess