Home > Archive > MS Access data conversion > December 2005 > Convert Access 2003 Back To Access 97 Problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Convert Access 2003 Back To Access 97 Problem
MikeW

2005-12-07, 7:25 am

When I use the Access 2003 utility to convert my database back to
Access 97, all the table links (ODBC to SQL Server) turn into local
Access tables. Has anyone run into this problem and what can be done
about it, if anything?

2005-12-08, 3:25 am

Delete the tables and create new links. The work of minutes:
file, import, as links.

The wizard is too dumb to recognise ODBC links. It assumes
all links are to Jet 4 tables, which won't be recognised by A97.

(david)

"MikeW" <mwhitson@msn.com> wrote in message
news:1133954804.989951.93560@g44g2000cwa.googlegroups.com...
> When I use the Access 2003 utility to convert my database back to
> Access 97, all the table links (ODBC to SQL Server) turn into local
> Access tables. Has anyone run into this problem and what can be done
> about it, if anything?
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com