ODBC connectivity

  • Hello every one,

    I’ve a wired problem. From Access 2003 we’ve ODBC connection to a Sql2000 database, resides on Windows 2003 (SP1) server. We linked to some tables on one particular database in SQL. Most of the linked tables are working fine, only 2 linked tables are giving ‘ODBC call failed’ error when we try to retrieve data (or click on those). I’ve checked permission and rights, there are no discrete rights assigned to these tables in SQL. To roll out Permission issues I’ve used SA user name and password in ODBC connection. I’ve checked the MSJet40.dll, it has the latest service pack on both in workstation and in the server. I can’t delete the link and reestablish it, because whole lot of other Access queries and tables are related (depended) on these tables.

     

    I will highly appreciate if some one helps me to troubleshoot this. Again all the linked tables are working fine, while only two linked tables to the same database are not working.

     

    Thanks

  • http://support.microsoft.com/kb/303257

    check if the above kb article applies to your scenario.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Thank you Sugesh,

    No! that did not help. I had checked it earlier. I have latest service packs for MSjet40.dll.

  • You have made changes to the table since you linked them. Delete the links and relink the tables.

  • In Access, right-click on any linked table and then click Linked Table Manager. Check-mark the bad tables and click OK. This will refresh the links. You don't need to delete and re-create the links.

    This is a common problem. When you link to an ODBC data source, Access remembers the table schema. If the linked table is changed, Access fails with error 3146.

Viewing 5 posts - 1 through 5 (of 5 total)

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