Problems after converting from 97 to 2002/XP

J

Jørn

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

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create New Field Type=dbDecimal 2
Problem formatting dates from CSV file 2
Access 97 Windows NT Server to Access 2003 SAN problems 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
temporary BackEnd database for large resultset 5
XP, SP3 - Office 97-Word Print problem 6
Can't open my Access files after conversion from Access 97 to Access 2003 5
type mismatch error in macro in excel 0

Top