Converting to 97

M

M Wells

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.
 
B

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.
 
M

M Wells

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?
 
J

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?
Click to expand...

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

M Wells

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.
 
B

Brendan Reynolds

I'm sorry, there aren't any short-cuts. If you want to be able to use the
MDB under an earlier version, you must be very careful not to use any
features that were not available in the earlier version. The Decimal data
type is one such feature. As John has explained elsewhere in this thread,
you will have to modify the MDB in the later version, changing all Decimal
fields to a data type that was supported in the earlier version, before you
will be able to convert.

To avoid problems like this in the future, if you want to support Access 97
it is far better to develop in Access 97 and convert to a later version for
users that have the later version, rather than trying to develop in the
later version and convert back to the earlier one.

The ability to convert to an earlier version is probably best viewed as a
safety net to allow users to recover from accidental conversion to a later
version than as a standard development technique.
 
Top