ODBC Call Failure

[askjacq]

There is a database that many computers use that links to some sql tables. On all the computer that use Access 2007, it works great. On the one computer that uses Access 2010 (32 bit), we get the error message ODBC - CALL FAILED. If I run the linked table manager, do select all, and click ok, it works fine. I've done lots of research, shown the hidden objects, set the ODBC engine connection to 263, etc., but still get the same error. So ...



1) Are you aware of any settings that will fix this error?
2) Anyone know a macro (not VBA) that I can use to run the linked table manager? There is a RunCode that you can enter the LinkedTableManager, but it only opens it - doesn't actually run it. I need it to do the select all and ok.

Thanks!

[June7]

1. Sorry, no.

2. Doubt macro can do more than open the manager. Need VBA code to automatically refresh links or to change the link pathing.
http://www.ozgrid.com/forum/showthread.php?t=72493
http://forums.aspfree.com/microsoft-...ue-323364.html

[askjacq]

I have no clue how to do VBA's. Anyone else out there know how to do a linked table manager update macro?

[June7]

Does this help http://www.databasedev.co.uk/link-tables-macro.html