perhaps just posted, sorry create id key with autonumber with ado

[sal21]

how create idx field in mytable with autonumber with ado?

[HansV]

To add an AutoNumber field named idx in MyTable, open a connection CONN on the database, and execute the following SQL string:

Code: Select all

CONN.Execute CommandText:="ALTER TABLE MyTable ADD COLUMN idx COUNTER", Options:=adExecuteNoRecords

To create a primary index on that field, execute

Code: Select all

CONN.Execute CommandText:="CREATE INDEX PrimaryKey ON MyTable (idx) WITH PRIMARY", Options:=adExecuteNoRecords