change user permissions until table built

[idono]

Help!

How can I change the permissions of the current user so I can build a table then remove the granted permissions. I have thought of an ADO connection to the current database, but there just has to be a simple function to grant deleting and rebuilding a table then removing those permissions.

Any ideas would be greatly appreciated.

 

[idono]

For those interested this is how to do it.

Dim wks as Workspace

Set wks = DBEngine.CreateWorkspace("NameOfWks", "UserName", "Password&quot

This will log the user in programmatically as whatever user is specified. They can then perform any operations the username has associated with it.

Doug