Converting to 97

[Guest]

Converting from 2002 to 97 Errors. I am getting a errors when converting
back to a 97 Access version. In addition to the missing library which I am
bypassing I get a field size to long error. What could be causing this, and
how do I fix.

 

[Brendan Reynolds]

If memory serves, I believe the Decimal field type was new in Jet 4 (Access
2000). I don't have Access 97 on this PC, but you can check for yourself by
opening any table in design view in Access 97, selecting any field of data
type Number, and checking the drop down Field Size list to see if Decimal is
an item in the list.

 

[Guest]

Decimal is not an option in 97. Do you know of a way to bypass this field
size error when converting to a 97 file format?

 

[John Vinson]

Decimal is not an option in 97. Do you know of a way to bypass this field
size error when converting to a 97 file format?

Save a copy of your database in 2000 format; manually change all the
Decimal fields to either Currency (if 4 decimals will be enough) or
Double. Convert this database instead.

John W. Vinson[MVP]

 

[Guest]

I have been pounding the keyboard looking to see what is available. I do
know for a fact that DAO 3.51 is an available reference and is checked on my
module. I also went another step to make sure that DAO350.DLL is on my C
drive and it is. Not sure what to do now to allow me to convert my A2002 to
A97.

P.S. I am new to A2002 so do not know all the short cuts. PLEASE HELP.