I originally had a Access 2003 app connected to SQL backend. This was running on XP, Vista and W7 still using 2003 Access.
Now I have Vista & W7 64bit trying to run the application using 2010 Access. I setup my SQL ODBC connections the same, but am getting "Login failed for user' Reason: Not associated with a trusted SQL Server Connection.
I guess I'm confused between the relationship of these different versions. In Access this is my connection string for the database using the DSN
BaseCS = "PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=LeadTrack;DATA SOURCE=APMPRO;Use Procedure for Prepare=1;Auto Translate=True"
Thanks for any help in this problem
Marnie
Now I have Vista & W7 64bit trying to run the application using 2010 Access. I setup my SQL ODBC connections the same, but am getting "Login failed for user' Reason: Not associated with a trusted SQL Server Connection.
I guess I'm confused between the relationship of these different versions. In Access this is my connection string for the database using the DSN
BaseCS = "PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=LeadTrack;DATA SOURCE=APMPRO;Use Procedure for Prepare=1;Auto Translate=True"
Thanks for any help in this problem
Marnie
Last edited:
