Setting Defaults in Create table statement?

  • Thread starter Thread starter Thomas Malia
  • Start date Start date
T

Thomas Malia

How do you do the equivalent to the following in Access 2000? No matter
what I try I get a syntax error:



CREATE TABLE SQLProcs
(
RecID AUTOINCREMENT ,
Name VarChar(50) NOT NULL ,
SysOrAppDB VarChar(50) NOT NULL DEFAULT 'A', <--- I can't figure out how
to set a DEFAULT using SQL in access!?!?!
RebootDSLIfRebuilt Bit NOT NULL DEFAULT 0,
RebuildIfExists Bit NOT NULL DEFAULT 0,
CreateString TEXT NULL
)
 
You may have to execute it programmatically under ADO for that approach to
work.

This kind of thing:
CurrentProject.Connection.Execute "CREATE ...
 
Back
Top