Linked Tables

[Trish]

I'm looking at a system with "linked tables". We are
trying to move the system off of a Novell server to a
Windows 2003 server. But everything crashes saying that
it can't find the files. I've narrowed down the issue to
the linked tables. Apparently it is hard-coded somewhere
inside access and the only way I've been able to fix the
issue is through the Linked Table Manager. This has
brought up another issue in that each of the databases
seems to be in different versions of Access. Some are in
97 and some are in 2000. I can only change the links if
the database is in the version of Access that I'm
running. ARGH.

Is there a way to programmatically update these linked
tables so that if we decide the move them again it won't
be a problem?

 

[Guest]

hi,
try this site.
http://www.mvps.org/access/tables/tbl0009.htm
it is about re-linking the fe/be using code.
I have not had a chance to use it yet. i just made a note
about the site. might be useful someday.

 

[Trish]

I have tried that but it is giving me an error.
User Defined Type Not Defined

On the following line..

Function fIsRemoteTable(dbRemote As Database, strTbl As String) As Boolean