Hi guys !
Here is my question: I am trying to create a table with default values using SQL statements within Access. I use the following Query:

CREATE TABLE Table1 (Name VARCHAR NOT NULL, Num INTEGER DEFAULT 0);

Our friend Access returns an error on the word "DEFAULT"... Could you explain me why and how to solve the problem please?

Thanks in advance !

Hi ,
in access query it doesn't seem to work the 'DEFAULT' word . If you delete 'DEFAULT 0' it will work perfectly .

thx for your help!

after hours browsing on the internet i found a solution ! the DEFAULT keyword only works on ADO tables ! On DAO tables it does not exist...