Converting Access 2000 back to 97

[deb gerdes]

I am trying to convert an Access 2000 database back to Access 97. It has
tables linked to SQL Server. When I try to go to convert it back to 97 it
converts the Linked tables into Access tables. Is there any way to convert
back to 97 and still keep the tables linked?

 

[Andi Mayer]

I am trying to convert an Access 2000 database back to Access 97. It has
tables linked to SQL Server. When I try to go to convert it back to 97 it
converts the Linked tables into Access tables. Is there any way to convert
back to 97 and still keep the tables linked?

why not delete the tables and relink it?

 

[deb gerdes]

I can delete the tables, but I will not be able to relink them after the
database is converted to 97. The problem is that I don't have a copy of
Access 97 anymore. I need a 97 version of the app in order to share it with
outside entities. I've just come to the conclusion that I can't do this.

 

[Andi Mayer]

I can delete the tables, but I will not be able to relink them after the
database is converted to 97. The problem is that I don't have a copy of
Access 97 anymore. I need a 97 version of the app in order to share it with
outside entities. I've just come to the conclusion that I can't do this.

why you can't link them?

is the 2000 version working? then you know the connection string

 

[Brendan Reynolds]

My understanding is that the convert to 97 feature was intended to allow
users to recover from accidental conversions. I don't believe that it was
ever intended to support a 'develop in 2000, deploy in 97' scenario.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[david epsom dot com dot au]

Those table links - and tables - are probably not compatible with
Access 97, so your options are limited.

Access 2000+, and recent versions of SQL Server, normally use
'unicode' or 'nVarChar' fields for text. nVarChar fields can't
be used by A97, and if any of your tables use nVarChar fields
you won't be able to link to them.

On the other hand, if this is a old database, using VarChar
fields for text, just delete all the tables/links and then
re-create the links.

You will be able to re-create the links in the A97 database
when you open it in A2000. You won't be able to change any
of the forms or reports, but you will be able to change queries,
macros, tables, and links.

If you have any trouble re-creating the links, you could also
use any of the sample code available to re-create the links.
The sample code often demonstrates linking CurrentDB, but you
can link any database (dao code uses OpenDatabase) using code,
include A97/A2.0 databases.

(david)