Connecting Tech Pros Worldwide Forums | Help | Site Map

linked tables in 97 version not showing up in 2003

sparks
Guest
 
Posts: n/a
#1: Jun 28 '07
We have an older database done in access 97 and some of its reports
use linked tables to another database.. it works fine when opened in
access 97.

One of the people using the database only has access 2003 installed
and when they try to open the reports it says that it can't find the
tables and they are not listed in the tables.

how can I correct this without converting everything to 2003 or some
such...it has to remain a 97 database.

thanks for any help this is rediculious as far as I am concerned.


Tom van Stiphout
Guest
 
Posts: n/a
#2: Jun 29 '07

re: linked tables in 97 version not showing up in 2003


On Thu, 28 Jun 2007 20:28:52 GMT, sparks <jstalnak@swbell.netwrote:

I have never seen this behavior, but confronted with it, I would use
Tools Add-Ins Linked Table Manager in A97 and remember where it
links to. Then use File Get External Data Linked Tables in A2003
to re-establish the links.

-Tom.


Quote:
>We have an older database done in access 97 and some of its reports
>use linked tables to another database.. it works fine when opened in
>access 97.
>
>One of the people using the database only has access 2003 installed
>and when they try to open the reports it says that it can't find the
>tables and they are not listed in the tables.
>
>how can I correct this without converting everything to 2003 or some
>such...it has to remain a 97 database.
>
>thanks for any help this is rediculious as far as I am concerned.
>
Closed Thread