Board index » delphi » Alter Access Table

Leif Eirik Olsen

Delphi Developer

Sat, 29 Oct 2005 14:07:02 GMT

Alter Access Table

Hi,

Hope this is the appropriate group this question.
I have a table in an Access (2000) DB with a column of type number : Decimal
(18,2). I need to change this to Number : Decimal (18,4) using SQL, but
can't seem to find the syntax to do it. Among others, I tried this :

ALTER TABLE DebtorLine ALTER COLUMN AmoutBto Decimal(18,4) : But this fails.

Is there anyone out there with a hint or clue to solve this ?

Thanks in advance,
Leo

Brian Bushay Team

Delphi Developer

Sun, 30 Oct 2005 10:14:30 GMT

Re:Alter Access Table

Quote

>ALTER TABLE DebtorLine ALTER COLUMN AmoutBto Decimal(18,4) : But this fails.

>Is there anyone out there with a hint or clue to solve this ?

I believe you need to be using ADO and Jet 4.0 for that syntax to be supported.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

2. Lock Access table prior to ALTER TABLE

3. IB6.0 Bug? ALTER TABLE ALTER Fieldname

4. MS Access ALTER TABLE problem - urgent!

5. Alter MS Access Table with ADO

6. ADO, Access 2000, ALTER TABLE

7. ADO, Access 2000, Alter Table and AllowZeroLength

8. Alter Table statement and MS-Access from Code ...

9. CREATE TABLE vs CREATE TABLE + ALTER TABLE

10. altering the table language of an existing table