I have multiple SQL Server Instances, I am trying to write a simple Access App that I can use regularly to collect some information about these instances. The problem I'm facing is connecting; I have 2 LAN Id's, one being 'me' and the other 'me.admin'. 'me.admin' has access to query the SQL servers and get the data I need, but 'me' does not. The obvious solution would be to log out of the network, and then login with 'me.admin' to build/run my reporting tool, but that sure would be a pain, is there any other way that I can accomplish this when the SQL Servers use only Windows Authentication? Unfortunately giving 'me' appropriate SQL access is not an option, is it possible to specify, or prompt for windows credentials to feed the DSN or Connection String?