Help with SQL create table

[John Cosmas]

What statement would I use to complete a CREATE TABLE statement so that I
can set a DEFAULT value in the first field. I figured out the NOT NULL, but
can't get the DEFAULT to work.

 

[Van T. Dinh]

Where are you using the CREATE TABLE ... SQL?

IIRC, the DEFAULT constraint / clause does not work through the Access
interface or DAO code. I think you need to use the JET OLE DB Provider with
ADO code if you want to use the DEFAULT clause in your SQL.