Hello. Can someone help me with this one...

I need to alter a DBF structure to change a numeric datatype precision and scale.

Using ADO, I have tried to use the "ALTER TABLE <dbf> ALTER COLUMN SALES n(11,2)", but error "Incorrect syntax on ALTER TABLE."

I have read on msdn doc that ALTER command does not work on Microsoft Jet Engine. So I tried DAO, "Opendatabase", but access denied/permission error occured.

I will really appreciate any help or suggestion....

Thanks in advance.