error in creating a field

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

I'm using DAO in Access 2000.

This works:

With MyTabledef
.Fields.Append .CreateField("CustID", dbLong)
End With

This does NOT:

With MyTabledef
.Fields.Append .CreateField("CustID", dbDecimal)
End With

Can anyone tell me why? How can I create a decimal field?

Thanks in advance,

Tom
 
From memory, I don't think Microsoft bothered updating the DAO library to
support the Decimal field type that was new to JET 4.

If you are mad enough, you can create the field with a DDL query statement,
or ADOX. However, the Decimal field type is so buggy and poorly implemented
that you are better off without it. Access can't even sort it properly:
http://members.iinet.net.au/~allenbrowne/bug-08.html
 
Back
Top