Database Conversion: Access 2003 to 97

Database Conversion: Access 2003 to 97 - Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access rookie - 14 Jan 2005 20:05 GMT

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.

Reply to this Message

John Vinson - 15 Jan 2005 01:09 GMT

>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]

Reply to this Message

Access rookie - 15 Jan 2005 16:13 GMT

Hey John,

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

John.

> >Hello,
> >I've been developing a DB in Access 2003 and have been saving it under the
[quoted text clipped - 14 lines]
>
> John W. Vinson[MVP]

Reply to this Message