Create AutoNumber Field in DDL

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

Guest

It appears there is no facility for creating an AutoNumber data type field
using DDL.
I need to update database schema changes to some 50 regional mdbs. This
includes creating new tables and modifying table definitions.
 
Klatuu said:
It appears there is no facility for creating an AutoNumber data type
field using DDL.
I need to update database schema changes to some 50 regional mdbs.
This includes creating new tables and modifying table definitions.
Click to expand...

CurrentDB.Execute "CREATE TABLE myTable (id counter PRIMARY KEY)"
 
Back
Top