Can MS-Access 2003 Impersonate Windows user?

[NCYankee1]

Hi

I have been given the task of converting an MS-Access 2003 application whose database currently resides on SQL2000 (mixed mode) and move the database to SQL2005. They want the database to reside on a Windows Authentication Mode SQL Server. This means that I would need to impersonate a Windows domain account that has authorization to hit that database. The MS-Access app links to the SQL tables and also calls stored procs on the SQL Server. Is there a way for MS-Access to impersonate a Windows user?

 

[dhookom]

May be possible if you can open Access with "Run As" to run Access with a different user account.

Duane
Hook'D on Access
MS Access MVP