Using Linked Table Manager after converting A95 db to A2003

[Jack McAfee]

I have converted an A95 db to A2003. I need for some users to be able to use
previous versions of Access with the db. Hence, I use the database splitter
to create a backend db. Then I deleted it as per instructions on MS Help and
then opened the A2003 db. Next I am to use the Linked Table Manager to link
back to the original database. However, when I click on Linked Table
Manager, I get a dialog box with no tables listed to refresh or update the
source. When I look at the A2003 db window, it shows the tables are linked
by using the -> in front of the table name. Why am I not seeing the tables
in the Linked Manager dialog box?

Also, assuming I can link back to the A95 db, when I open under A2003 will I
be able to append data from Excel files to selected tables using the Get
External Date function?
Jack

 

[Douglas J. Steele]

Have you installed all of the service packs for Access 2003? I believe the
Linked Table Manager issue was corrected by SP1. However, if you can't get
it working, you can always write your own code to relink the tables. See
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for one
approach.

As to whether you'll still be able to append to Excel, the answer is
probably not (again, it depends on whether you've applied all of the service
packs). The fact that your back-end database is Access 95 is irrelevant:
you're using Access 2003 for the application.

 

[Jack McAfee]

Actually, MSOffice 2003 has a SP2 out now. Had problems getting it installed
but finally managed by doing the install from the Web site. Then, everything
worked like a charm. Was able to append Excel files to the db in A95 format
and execute the application using the db. Thanks for your help.
Jack