MS Access ALTER TABLE problem - urgent!

Nikica Tarandek

Delphi Developer

Tue, 25 May 2004 05:05:20 GMT

MS Access ALTER TABLE problem - urgent!

Hello!

Could someone, please, tell me how can I execute this as MS Access 2K query:
ALTER TABLE [TableName] ALTER COLUMN [FieldName] DOUBLE (15,2)

Table and field exist and I want to change from Number (Double) type with
Auto precision to Number (Double) with 2 decimal places precision.
MS Access reports syntax error at first bracket, while this works perfectly
on SQL Server 7/2K!

I could not find anything about this in MS Access help :-(

Thank you in advance!

--
{[n!k!ca]c0d!ng*4[$||:)]}

John Mishefsk

Delphi Developer

Wed, 26 May 2004 09:16:11 GMT

Re:MS Access ALTER TABLE problem - urgent!

The DecimalPlaces is a property and not setable through SQL.
You could modify it in code using the TableDef and Field objects.

DecimalPlaces, however, does not determine how numbers are stored
but how they are displayed. Do you really need to change this?

The DecimalPlaces property setting has no effect if the Format
property is blank or set to General Number (from A2K help).

--
'-------------------------------
' John Mishefske
'-------------------------------

Quote

Nikica Tarandek wrote:

> Hello!

> Could someone, please, tell me how can I execute this as MS Access 2K query:
> ALTER TABLE [TableName] ALTER COLUMN [FieldName] DOUBLE (15,2)

> Table and field exist and I want to change from Number (Double) type with
> Auto precision to Number (Double) with 2 decimal places precision.
> MS Access reports syntax error at first bracket, while this works perfectly
> on SQL Server 7/2K!

> I could not find anything about this in MS Access help :-(

> Thank you in advance!

> --
> {[n!k!ca]c0d!ng*4[$||:)]}

curio

Delphi Developer

Fri, 28 May 2004 14:21:15 GMT

Re:MS Access ALTER TABLE problem - urgent!

Quote

"Nikica Tarandek" <nikica.taran...@ck.tel.hr> wrote in message <news:9ur4fs$8dla$1@as201.hinet.hr>...
> Hello!

> Could someone, please, tell me how can I execute this as MS Access 2K query:
> ALTER TABLE [TableName] ALTER COLUMN [FieldName] DOUBLE (15,2)

> Table and field exist and I want to change from Number (Double) type with
> Auto precision to Number (Double) with 2 decimal places precision.
> MS Access reports syntax error at first bracket, while this works perfectly
> on SQL Server 7/2K!

Try to skip brackets

Other Threads

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

2. Alter MS Access Table with ADO

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

4. Problems accessing MS-Access Database - urgent

5. Lock Access table prior to ALTER TABLE

6. Problem accessing MS Access odbc database after installing MS SQL7

7. IB6.0 Bug? ALTER TABLE ALTER Fieldname

8. ADO, Access 2000, ALTER TABLE

9. ADO, Access 2000, Alter Table and AllowZeroLength

10. Alter Access Table