Script a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top