E
EAB1977
Hi guys,
I am using Access 2003 as a FE to a database that I am using. All the
SQL Server tables are read-only as I am using this in queries.
When I try to run one of my queries, I get a connection failed error
4060 from the SQL Server. I have determined that this is caused by the
trusted connection checkbox being checked when I run my refresh tables
VBA code. I have re-established a SQL Server DSN file with a SQL
Server specific user ID and password. When my code runs, I still get
the error and the trusted connection string checkbox being checked.
Is there anything I am doing incorrectly?
I am using Access 2003 as a FE to a database that I am using. All the
SQL Server tables are read-only as I am using this in queries.
When I try to run one of my queries, I get a connection failed error
4060 from the SQL Server. I have determined that this is caused by the
trusted connection checkbox being checked when I run my refresh tables
VBA code. I have re-established a SQL Server DSN file with a SQL
Server specific user ID and password. When my code runs, I still get
the error and the trusted connection string checkbox being checked.
Is there anything I am doing incorrectly?