Add an AutoNumber field(ADO)

[wperzel]

Can someone suggest the proper "Append" or "CreateField" statement to add an AutoNumber field to an existing table programatically in ADO? I have found an example for DAO but it does not work in an ADO environment.

Warren

 

[Alexandre]

Create a data-definition query. You can execute it from VBA. Have a look to ALTER TABLE in Access help.
Re-post if needed.

Alex