Re: Column with decimal

On Mon, 9 Jul 2007 05:16:08 -0700, DotNetWork
<DotNetWork@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Using Access 2003 And Visual Studio 2003,
I'm trying to create a decimal column using the Followed SQL Command:

'ALTER TABLE [Table1] ADD COLUMN [Data1] DECIMAL (10, 2);'

The response is the error [42000] Sintax error in ALTER TABLE.

The question is where is the error?

The DDL supported by Access is often a few lightyears behind what
Access supports through the Access user interface. For example, in
Access 2000 one can certainly create columns of type Decimal(10,2) in
the table design view; however, the DDL doesn't support the Decimal()
column type.

In approx. 15 years of experience using MS-Access, I have come to the
conclusion that it is only useful as a front-end ... UNLESS all of
the front-end clients are also Access MDB's linking to Access tables,
and only if the structure of the back-end DB does not need to be
modified through the clients.

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.