error in creating a field

[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

 

[Allen Browne]

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