Problems after converting from 97 to 2002/XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After converting from 97 to 2002/XP we get an 3259 "invalid field data type"
when trying to make a CreateField with the type of Decimal (dbDecimal = 20).
We found out that we can make fileds of the type of 1 - 17 but not the rest
(18 - 23).
Anyone else having the same problem?
 
If memory serves correctly, DAO was not enhanced to handle the Decimal field
type, nor many of the other things in JET 4.

In any case, you do not want to use this field, as it is poorly implemented,
and does not even sort correctly. Details:
http://members.iinet.net.au/~allenbrowne/bug-08.html

What I find curious, though is how you ever managed to CreateField of type
dbDecimal in Access 97.
 
Back
Top