URGENT: How can I Alter the DBF structure in VBA?

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.

Moved from ClassicVB

Yes, I have read some of the threads. I also have tried some of it but it still does not work. I still cannot alter the dbf structure.

here
The response to the post is something about dbase only allowing 10 chars ? And you are trying for 11+2? or 11 and 2 decimal places?