?
Solved

Ms Access/SQL Server db connection errors

Posted on 2012-09-12
6
Medium Priority
?
1,156 Views
Last Modified: 2012-10-26
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
Comment
Question by:kenabbott
  • 3
  • 3
6 Comments
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 38391622
Which version of Windows are you using???.  I would first delete the System DSN on the problem machine then recreate it.

ET
0
 

Author Comment

by:kenabbott
ID: 38391632
Both are Windows 7.  I have tried deleting dsn and recreating but still same problem.
0
 
LVL 19

Expert Comment

by:Eric Sherman
ID: 38391662
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:kenabbott
ID: 38412803
Hi

I have tried this, still the same error

ken
0
 

Author Comment

by:kenabbott
ID: 38412816
Also I have tried connecting via Excel and this works
0
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 2000 total points
ID: 38414165
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question