I've searched the internet for what could be my problem, but couldn't find anything, so I'm posting this hoping someone can help.
I have an Access 2007 database with linked tables to SQL Server 2008. In the On Open event for my main menu, if the user's ODBC data source has not been set up on his/her PC, I want to programatically set it up. Here is the code I have:
While the ODBC data source does get set up, it is not set up as a trusted connection. The attached document includes a screen print from the ODBC Data Source Administrator after this code runs. It should be verifying login ID authenticity through Windows NT authenentication.
I thought that stating "Trusted_Connection=Yes" would address this, but apparently it does not. How can I get this to programatically set up the data source with Windows NT authenentication?
I have an Access 2007 database with linked tables to SQL Server 2008. In the On Open event for my main menu, if the user's ODBC data source has not been set up on his/her PC, I want to programatically set it up. Here is the code I have:
Code:
DBEngine.RegisterDatabase "FinancialPlanningAnalysis", "SQL Server", True, _
vbCr & "Server=itasql55pr" & vbCr & "Database=FinancialPlanningAnalysis" & vbCr & "Trusted_Connection=Yes"
While the ODBC data source does get set up, it is not set up as a trusted connection. The attached document includes a screen print from the ODBC Data Source Administrator after this code runs. It should be verifying login ID authenticity through Windows NT authenentication.
I thought that stating "Trusted_Connection=Yes" would address this, but apparently it does not. How can I get this to programatically set up the data source with Windows NT authenentication?