[thelist] Coldfusion & MS Access SQL Resource Wanted

rudy r937 at interlog.com
Sat May 11 15:36:01 CDT 2002

>   ALTER TABLE ForumThreads
>   ADD NumberofViews INT
> but i get errors saying invalid SQL syntax...
> so does Access set defaults in some wierd way?

not weird, just limited

only some ddl (data definition language) is supported, not all --

  HOWTO: Common DDL SQL for the
  Microsoft Access Database Engine (Q180841)

you can alter the table to add an integer column, but you cannot set the
default value, and i believe it allows nulls even if you specify not null

do table design on your local database copy, and then upload


More information about the thelist mailing list