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

On Thu, 28 Jun 2007 20:28:52 GMT, sparks <jstalnak@xxxxxxxxxx> wrote:

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.



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.


.

Relevant Pages

  • Re: Access Add-in Manager
    ... Access 95) listed the default Add-ins (Database Splitter, ... Manager, Switchboard Manager and Upsizing Wizard), in the "Add-ins" menu ... the Add-in Manager registers the Add-in in the Windows Registry and ...
    (microsoft.public.access.modulesdaovba)
  • Re: Contemplating A97 to A2003
    ... "Leslie Isaacs" wrote in message ... A2003 is more stable than A97 to develop in. ... technology such as PHP to read/write the Access database. ... > 3) a developer whose services I would like to use for some small projects ...
    (microsoft.public.access.conversion)
  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)
  • Re: Using Access 97 with Project
    ... "Earl Lewis" wrote in message ... Can the MSP2002 then read the A97 database after its converted? ... Is it possible to keep the Db created with MSP in A2k format and link ...
    (microsoft.public.access.externaldata)
  • Re: Need multiple manager tables that can be sent to individuals
    ... Ideally, we'd have one Master table that contains all employee data. ... I'd also have one table with all the same fields for each manager to key in his/her employees' data. ... When I set up the Master table and then two individual managers tables, I tried using the database splitting feature to get just one manager's table out as a separate file. ...
    (microsoft.public.access.gettingstarted)