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.