Database Conversion: Access 2003 to 97 - Help!

[Access rookie]

Hello,
I've been developing a DB in Access 2003 and have been saving it under the
2000 file format. My deployment enviroment runs Access 97; I thought I would
simply use the convert Database command. It's not working! It gives me a
invalid data type error; the ensuing message tells me it wasn't converted.

What do I do?

Feeling like a deer caught in the headlights of a semi,

John.

 

[John Vinson]

Hello,
I've been developing a DB in Access 2003 and have been saving it under the
2000 file format. My deployment enviroment runs Access 97; I thought I would
simply use the convert Database command. It's not working! It gives me a
invalid data type error; the ensuing message tells me it wasn't converted.

This might be from a number of causes. Be certain you haven't used any
A2000+ features not found in A97 (such as Conditional Formatting);
doublecheck the datatypes of all your table fields (I don't think A97
supported Decimal for instance). Compact and repair the database;
open the VBA editor and compile, and fix all compilation errors.

If necessary you may need to do this piecemeal - create a database
with JUST the tables, no forms or code or reports, and try converting
it; then add other objects, one or a few at a time, and see which
breaks the conversion. Good luck!

John W. Vinson[MVP]

 

[Access rookie]

Hey John,

Thanks for your reply...I will see what I can do!

John.