Conversion problem from 2000 to 97

[Guest]

I need to convert this application from Access 2000 to Access97. It was
originally developed in Access97. First I am warned that I am missing an
object library for Access97 (that can be found on the computer runnin
Access97), but then the conversion is stopped because of an "Invalid field
data type". I have checked my data types in tables, but don't find anything
unusual. Can you tell me what I am looking for, and where to look for it?

 

[Guest]

Hi Bob,

If you are willing to send me a compacted and zipped copy of your database,
I'll take a look at it for you. My e-mail address is available at the bottom
of the contributors page indicated below in my signature.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Allen Browne]

At what point does the conversion fail?

Are you able to create a new (blank) Access 97 database (using Access 97).
Then use Access 2000 to export the objects to the new database?

You may find thaat you can export the tables, relationships, and queries,
but it fails when exporting a particular form. There is a bug in the
conversion code, so that it wrongly creates a label instead of a text box,
and then the conversion process fails when it tries to assign the
ControlSource, since labels don't have a ControlSource property.