Hi all 



I am using Access 2000 as a backend to my ASP stuff and am getting syntax 

errors when trying to add new columns. I have done exactly this with MySQL 

and Fox which I am sure did work.



What I have is 



strSQL="Alter table vehicles add column newprice DECIMAL(5,2);"

This is then fired off via an ADODB.Command.

Which gives an error.



If I just use DECIMAL it works fine, the same goes for float, int etc.

How do I specify the length and precision of a field at "add column" time?



Thanks in advance



Regards

Graham