I have set up a number of Linked Tables using the usual "Link Table" function in Access 2003. However, I am continually having to re-link these tables when I get the message "ODBC--Call Failed" then it works for a while longer. Is there another method of linking via ODBC which would prevent me from having to re-link all the time ??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2003 - ODBC Link Table Error
- Thread starter PremPaulw
- Start date
ArtieChoke
Programmer
Don't know why it would break the link, but you can create a file DSN and see if that works any better.
"I think we're all Bozos on this bus!" - Firesign Theatre![[jester]](/data/assets/smilies/jester.gif "[jester] [jester]")
"I think we're all Bozos on this bus!" - Firesign Theatre
- Status
Similar threads
- Locked
- Question
- Locked
- Question