Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Access 2007 gives "ODBC--call failed" error message

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-11-2010
Member
 
Join Date: Oct 2010
Posts: 15
Access 2007 gives "ODBC--call failed" error message

I am running Access 2007 SP2 on my Windows 7 which is having SQL server 2008 as backend. It works fine when I try to link and relink SQL server 2008. However, the problem occurs when I try to link the table manager by relinking with "Always prompt for new location" option selected. I get an ODBC error message when I do so which says the call failed. There error message only gives me the option to click on OK to close the message window but there is no information about it. This happened since I have installed Office 2007 on my computer. This was not the case with my previous installation, which was Access 2003. Does new office suite is the culprit? Can I do something about it?

Reply With Quote
  #2  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,514
Re: Access 2007 gives "ODBC--call failed" error message

"ODBC Call Failed" error occurs when you are attempting to run a query which has an outer join on a linked SQL Server table. Microsoft already know about this problem and in fact they have come up with the solution to the problem. They have already released a fix with the latest edition of the Jet Service Pack. All you have to do is install the latest Jet update to keep your Jet database in good working condition. Before going for the latest Jet database, check out the current service pack level. Go to Start, and then click Search. In the Search Results pane, click on All files and folders. In the All or part of the file name box, type Msjet40.dll, and then click Search. In the search result that is produced, right-click on the Msjet40.dll file (which must be located in the Windows\System32 folder or in the Windows\System folder) and then click on Properties. Click the Version tab, and then determine the current Jet 4.0 service pack level.
Reply With Quote
  #3  
Old 30-11-2010
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Access 2007 gives "ODBC--call failed" error message

There are couple of suggestions to your problem. How are you trying to relink? Are you selecting a lot of tables when you are selecting "Always prompt for new location" option? Do you see any changes when making necessary changes over here like selecting only one table instead of couple of them or vice verse? I said so because may be you have a some tables which is causing the trouble. Try to make a new blank Access database and try to link it to your SQL table. Can you notice the same error message? Also check out the same test with some other database on your SQL Server and see if the database produces this error? Also try the above test with some other computer to ensure it is not system related problem. Once you are confirmed about this not being the case then you can take your test further by viewing ODBC trace or Process Monitor Log to see if there is anything mentioned about the cause of the failure.
Reply With Quote
  #4  
Old 30-11-2010
Member
 
Join Date: Oct 2010
Posts: 15
Re: Access 2007 gives "ODBC--call failed" error message

I have tried linking and relinking on another computer which is running Windows XP and never faced any problem. This happens only on the computer which is running Windows 7. I have also observed that the same thing works on Access 2003 on the same Windows 7 computer. So I think the problem lies with my Access 2007 installation. I think may be the problem lies in the installation package but since I am not sure about this I came here to ask you about any suggestions. Do you think I should reinstall Access 2007 on my computer or the Office 2007 suite itself completely? I am thinking of to install Access only because I never noticed any problem on other office suite package like Word, Powerpoint, Excel etc.
Reply With Quote
  #5  
Old 30-11-2010
Member
 
Join Date: Jun 2009
Posts: 1,518
Re: Access 2007 gives "ODBC--call failed" error message

This kind of error message is quiet normal and expected. This happens if any instance fails resulting into closing of all connections. It is similar to shutting down your server and restarting it once again. In spite of this, your ODBC test created a new connection and it is back to normal in working condition. But Access is unaware about this and could not even know how to restart once the connection is lost. This is the main reason why it fails. If possible, then you can definitely customize your code by including error handling and reconnecting to the database once this kind of problem occurs. You can even mention how it can detect this problem and how to deal with situations. You can even take care of if you want the user to know about this problem or else let him be transparent to this situation.
Reply With Quote
  #6  
Old 01-12-2010
Member
 
Join Date: Nov 2008
Posts: 996
Re: Access 2007 gives "ODBC--call failed" error message

Which ODBC driver and version are you using? Did you tried out a different ODBC driver in your DSN to ensure if that fixes the issue. This connection error may even occur if you are missing any service pack that you need to install. Check out the official site and see if there is something that you need to install which supports Windows 7. Yes operating system place an important role over here and you should take special care about it. Also make sure you have the proper permissions for the tables on the server. Then check out the server connection timeout that is set.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Access 2007 gives "ODBC--call failed" error message"
Thread Thread Starter Forum Replies Last Post
Error message " DNS name has resolved, failed to join with Domain" with windows 7 Jigya L. Networking & Security 5 21-03-2011 10:00 AM
When you run Dcpromo.exe on Windows 2008 to create a replica domain controller, you receive a message "The operation failed because: A domain controller could not be contacted ... "Access is denied." John Wu Active Directory 4 15-05-2009 11:48 AM
Office 2007 "The installation of this package failed" error. Stel MS Office Support 1 11-01-2008 10:16 PM
Project Web Access via IE7: "Export Grid to Excel" cause VBSCRIPT (error) message: "The activeX control on which this feature depends could not be created" Theo-Dore Microsoft Project 2 17-01-2007 09:47 PM


All times are GMT +5.5. The time now is 06:27 PM.