asked on

Ms Access/SQL Server db connection errors

Hi

I have an MS Access db which has tables linked to a SQL Server db. There is no code involved only linked tables. This was working fine eg tables opened without problem. However when I try to pen a table now I am getting the following error

SQL State: 08004
SQL server error: 4060
Server rejected connection. Access to selected database has been denied.

If I try to link a table to the db I get the following error

SQL State: 37000
SQL server error: 4064
Cannot open user default database. Login Failed.

I have tested the system dsn upon which the link is based and this is working. The Access db itself is stored on a server and when opened on another PC works fine.

Any ideas what is going on here?

Eric Sherman

Which version of Windows are you using???. I would first delete the System DSN on the problem machine then recreate it.

ET

kenabbott

ASKER

Both are Windows 7. I have tried deleting dsn and recreating but still same problem.

Eric Sherman

1.) Open a new blank Access db on the problem PC.
2.) Using the System DSN, manually link to a SQL Server table and see if it works.

ET

kenabbott

ASKER

Hi

I have tried this, still the same error

ken

kenabbott

ASKER