2000 Access to 1997 Access

[Mark]

I converted a database from Access 2000 to Access 97,

While the 4 tables and a sub-form were accessible in
Access 97, the main Form gave an reboot error.

Things about the main Form that may cause difficulty is
it has a "tab control" and has a subform. Other than
those two features it is a pretty straight forward design.

Is backward conversion just fickle? Would either of those
two features cause the error in Access 97? Is the "tab
control" considered an ActiveX Control feature which I
see can not be backward converted.

Thank you,
Mark

 

[GVaught]

By default Access 2000 databases use ADO and not DAO like Access 97.
Generally, when you convert backwards you need to make sure that you have
the correct references set. Ensure that the 97 database is using DAO 3.51
and compile your database to this reference.

 

[Mark]

How does one "ensure that the 97 database is using DAO
3.51 and compile your database to this reference."?

Thank you

 

[Mark]

I'm not doing anything in the Access 2000 to tell it to
use ADO. So it is not clear to me what I have to do to
make it use DAO 3.51.

Thanks Mark

 

[Tony Toews]

How does one "ensure that the 97 database is using DAO
3.51 and compile your database to this reference."?

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References. Then remove DAO 3.6 and add
DAO 3.51.

For a very detailed page on reference problems see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm