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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Primary Key AutoNumber Field 1
Autonumber and Make Table Query 1
Error in generating DDL query 2
Generating Jet DDL 14
dropping a relationship (i.e. constraint?) 7
Create Table in code 3
Update query with autonumber field 4
Trouble with autonumber field in a query 3

Back
Top