Script a table

[Guest]

i need to script a table

.....

create table tblName
(
ID autoincrement PrimaryKey,
Date DEFAULT '=Now()'
}

This doesnt work,

Its the default value i need help with.
I need to do the default value through a script not in
access design view

 

[Michel Walsh]

Hi,


CurrentProject.Connection.Execute "CREATE TABLE toto (ID AUTOINCREMENT
PRIMARY KEY DEFAULT now() )"



Try using ADO, not DAO, that means not using the query designer, among other
limitations. Personally, I use the immediate debug window.




Hoping it may help,
Vanderghast, Access MVP