• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1288
  • Last Modified:

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?
0
kenabbott
Asked:
kenabbott
  • 3
  • 3
1 Solution
 
Eric ShermanAccountant/DeveloperCommented:
Which version of Windows are you using???.  I would first delete the System DSN on the problem machine then recreate it.

ET
0
 
kenabbottAuthor Commented:
Both are Windows 7.  I have tried deleting dsn and recreating but still same problem.
0
 
Eric ShermanAccountant/DeveloperCommented:
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
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
kenabbottAuthor Commented:
Hi

I have tried this, still the same error

ken
0
 
kenabbottAuthor Commented:
Also I have tried connecting via Excel and this works
0
 
Eric ShermanAccountant/DeveloperCommented:
Ok ... Process of Elimination.

1.) On the problem pc the DSN Test checks out OK.
2.) On the problem pc the DSN works with another application (Excel).
3.) The Access db works on another pc.
4.) You only get the error when running Access on the problem pc.

Based on the items above, I would uninstall and then reinstall Office on the problem machine.  Seems like the problem is with Access on the machine that's throwing the error.

ET
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now