Convert a2000 back to a97

[Frank]

Hello

As a favor for a friend ( I should not volunteer as I
do ! )
I am working on a backend db written in Access 97 and used
by an off the shelf application. I only have access 2000.
I converted it to access 2000 (got a message that said I
had to or could not change the db) did some simple loads
and conversions and need to save it as an access 97 db so
that the app can use it. When I try the tools , db utils,
convert db to prior access version I get a message.
Your computer is missing at least one of the ms access 97
object libraries. YOur converted database will not work
with access 97 until you open this database using access
97 and then fix the missing references.

What will I have to "fix".
Should I attempt this some other way?

Thank you so much for your help
Regards
Frank

 

[John Nurick]

Hi Frank,

If you're just working on the data in the Access 97 mdb file, don't
convert it. Instead, create a new Access 2000 database and use linked
tables in that to connect to the data in the Access 97 file.

As for the problem with the references in the converted database, you'd
need to open it in Access 97, open a module, go to Tools|References,
restore any missing references, compile and save all modules (repairing
anything that won't compile), and finally test it.

 

['69 Camaro]

Hi, Frank.

Your computer is missing some of the DLL's or TLB's that come with Access
97, which is understandable. Most likely, your computer is missing
DAO350.DLL, which isn't required for Access 2K, since it uses the next
version, DAO360.DLL.

The proper way to fix the References is to open the application in Access
97, find the "MISSING" References in the References dialog window, delete
them, then add the correct References by browsing for the appropriate
library files, then compile the code.

It's possible that you may find someone who has Access 2000 on their
computer, but with some of the old Access 97 Reference libraries left over
from an old installation. If this is the case, then make a copy of your
Access 2000 version of the application for him to convert to Access 97 for
you. And remember, upgrading from one version to the next can be relatively
easy, but downgrading from one version to another has no guarantees that the
conversion will work properly in the earlier version of Access.

Thinking about other alternatives, you probably can't use your Access 2000
version with the "off the shelf" application, since the application probably
has the database connection hard-coded to use data access methods specific
to Access 97. Those simple loads and conversions you mentioned -- could
that data be imported into the original Access 97 database to replace the
data in the original tables? (You MUST make a backup first.) You can link
an Access 2000 database to tables in an Access 97 database to do this.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.