create access table with ado sql (cannot change table properties)

From: ercan (ercanaktin_at_pcm.com.tr)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 13:40:52 +0200

we have an access database and we want to modify the table field
properties.like format of double field to Currency .
is it possible to do it with sql ado.if yes how?
that works:
ADOCommand1.CommandText :=

'CREATE TABLE MUSTERI_ODEME ' +

' ( ' +' NAME TEXT(20) WITH COMP NOT NULL' +

' )';

ADOCommand1.Execute;

but this one gives error :

ADOCommand1.CommandText :=

'CREATE TABLE MUSTERI_ODEME ' +

' ( ' +

' NUMBER DOUBLE WITH FORMAT "CURRENCY" ' +

' )';

ADOCommand1.Execute;

Relevant Pages

  • Re: Currency Format Change In Styles-Justification
    ... But if I click on format|cells|number tab and use Currency (2 decimal places ... Click Modify ... new book.xlt template workbook. ... > to match the format in the manner as when you got to Format Cell ...
    (microsoft.public.excel)
  • RE: Regional settings modification
    ... Country Text Indexed ... This application is intended for different countries and differend currency ... They are still derived from the regional settings. ... simply copied the pound symbol and used it in the format property for text ...
    (microsoft.public.access.modulesdaovba)
  • Re: Currency conversion
    ... I agree that the way Access works with regard to currency ... format at all with a currency field, ... again it displays per regional settings. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Currency conversion
    ... If your data type is number and you want to format as currency but do not see it on the list, ... Currency fields to match their regional settings. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regional settings modification
    ... I am trying to avoid using Currency format, I use "standard" format instead, which do not show any currency symbol, and if symbol required - I showed it in a separate field. ... as for decimal symbol - I think there is no way to solve this, unless you change regional settings, what, as Doug mentioned, is A Bad Thing. ... "Rob" wrote: ...
    (microsoft.public.access.modulesdaovba)