Convert Access 2003 to Access 97: Linked Tables

[Ed Warren]

When I convert my Access 2003 to Access 97, the linked tables are converted
to local tables.

Is there a way to do the conversion and maintain the linked tables?

Thanks,

Ed Warren.

 

[John Vinson]

When I convert my Access 2003 to Access 97, the linked tables are converted
to local tables.

Is there a way to do the conversion and maintain the linked tables?

Thanks,

Ed Warren.

Open the backend database and convert *it* first; then convert your
frontend; then delete the tables and relink to the A97 backend.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Ed Warren]

Thanks for the response, I have been doing it the way you suggest, I was
hoping there was a 'software switch' somewhere I had missed. With some
applications I have a lot of tables and -- well anyway.

Thanks,

Ed Warren

 

[John Vinson]

Thanks for the response, I have been doing it the way you suggest, I was
hoping there was a 'software switch' somewhere I had missed. With some
applications I have a lot of tables and -- well anyway.

Relinking shouldn't be a problem; just use the Linked Table Manager.
You don't need to do them one at a time!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Ed Warren]

I integrate data from many backends, into my applications, so relinking,
although a solution, is not ideal.

Just hope someday all my clients grow up and move to Access 2003. Right now
I have to support all versions of Access from 97 up!!

I will have to explore linking via VBA, but that is also a pain with all the
different versions of DAO, ADO out there.

Thanks,

Ed

 

[Ed Warren]

Just a test to see if posts are going through -- please disregard.

Ed Warren