Post reply

ODBC Call Failed error relinking tables in Access 2007

  • June 4, 2007 at 5:52 pm

    #68682

    I have a new computer with Vista and Office 2007.  I have a number of applications where I have link SQL Server tables.  When I go to refresh the link and select the 'Allways prompt for a new location' option I get an ODBC -- Call Failed error.   

    Barry

  • June 4, 2007 at 7:59 pm

    #710757

    I did a bit more on this and did a trace on the ODBC DSN and picked up the following error message:

      DIAG [S1000] [Microsoft][ODBC Driver Manager] General error: invalid window handle (0)

    Looked this up a bit but none of the answers makes sense - does anyone have a simple solution????

    Barry

  • June 4, 2007 at 11:19 pm

    #710784

    Found the problem - I installed Visual Studio 2003 after Office 2007 Pro - I ignored the issues warning - must have overwritten on or more of Access dll's - did a repair of Office 2007 Pro and problem has gone away....

    Barry

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply