Converting 2000 to earlier vesion

[Guest]

I have two Access 2000 databases (one with the tables and one with forms, queries, coded, etc). I would like to convert them using the database utilities "convert database". Each time. The database with the tables converts with no problems. The database with the code not only fails but removes some the the libraries in the VB references. I have to go back in and add the references to even compile my 2000 databases. The conversion fails on code like
With myrecordse
=> .FindFirst findcriteri
End wit

Are there references I need to add before I can convert? Do I need to have the tables in the database instead of linked

Thank
Jim Tinder

 

[Douglas J. Steele]

Access 2000 used ADO by default, while Access 97 used DAO. It's possible
that your application is using ADO methods, which could make conversion
backwards very difficult.

With any code module open, select Tools | References from the menu bar,
scroll through the list of available references until you find the one for
Microsoft DAO 3.5x Object Library, and select it. Since you're not going to
be using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.x
Library

Once you've done that, go to the Debug menu and Compile your application.
It'll show you anything that needs to be converted by hand.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have two Access 2000 databases (one with the tables and one with forms,

queries, coded, etc). I would like to convert them using the database
utilities "convert database". Each time. The database with the tables
converts with no problems. The database with the code not only fails but
removes some the the libraries in the VB references. I have to go back in
and add the references to even compile my 2000 databases. The conversion
fails on code like:

With myrecordset
=> .FindFirst findcriteria
End with

Are there references I need to add before I can convert? Do I need to have

the tables in the database instead of linked?