MS Access make table query displays error

[IngDep]

Have an MS Access database that uses a 12-step make table queries against a Sql server database.

The error received on the 8th step is something like:

Microsoft SQL Server Logon

Connection failed:
SQLState: '01000'
SQL Server Error: 233
.
.
.
SQLState: '08001'
SQL Server Error: 11

Any insight as to the cause and resolution is sincerely appreciated.

Have compacted the database and also exported the tables created by steps 1 through 7 and requeried from another database. Still receive the error.

 

[lisaharris]

SQL State 01000 is a general warning
SQL State 08001 is cannot connect to the data source.

Appears to be an authentication to your SQL table. Is the password you're using valid? Does the SQL account have rights to the table?


__________
It's better to have loved and lost than live with the idiot for the rest of your life.