• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 28. Advanced Security Techniques > Accomplishing Prohibited Tasks by Lo...

Accomplishing Prohibited Tasks by Logging On as a Different User

Although you might not want particular users to be able to accomplish particular tasks, you might at times want to go behind the scenes and accomplish the task for them. As you saw in the preceding section, you can prohibit a user or group from creating new tables and queries. This is fine, except when you run into a situation in which your code requires that a temporary table be created. In this situation, you can write ADO and VBA code to temporarily log on as a different user, perform the process, and then log off.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint