Setting Defaults in Create table statement?

[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
)

 

[Allen Browne]

You may have to execute it programmatically under ADO for that approach to
work.

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