I currently have an ADP file developed using MS Access 2003. The SQL backend is on the server and my connection string is
PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=LeadTrack;DATA SOURCE=APMPRO;Use Procedure for Prepare=1;Auto Translate=True"
Now I have a Windows 7 machine running MS Access 2010 with 64-bit.
When I try to open my application, I get the error "Login failed for user. Reason: Not associated with a trusted SQL Servcer connection."
When I check the ODBC connection for my MS Access, it is listed, which I'm assuming got installed during installation of Office 2010.
Could it be possible that the MS Access Database driver is not handling the adp file?
Any assistance appreciated. Maybe I misunderstand the relationship between MS Access adp file and the SQL database backend. I inherited this system, so not sure how it was originally setup.
Thanks
Marnie
PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=LeadTrack;DATA SOURCE=APMPRO;Use Procedure for Prepare=1;Auto Translate=True"
Now I have a Windows 7 machine running MS Access 2010 with 64-bit.
When I try to open my application, I get the error "Login failed for user. Reason: Not associated with a trusted SQL Servcer connection."
When I check the ODBC connection for my MS Access, it is listed, which I'm assuming got installed during installation of Office 2010.
Could it be possible that the MS Access Database driver is not handling the adp file?
Any assistance appreciated. Maybe I misunderstand the relationship between MS Access adp file and the SQL database backend. I inherited this system, so not sure how it was originally setup.
Thanks
Marnie
