ALTER TABLE (adding AutoMunber field) 1

[PrgrmsAll]

I am trying to do alter a table (using a RunSQL statement within a VBA Module). All I want to do is to add a column at the beginning of the table named 'ID' and set its datatype to be AutoNumber. My statement is as follows:

ALTER TABLE tblANCILLARY ADD COLUMN [ID] AUTONUMBER

It appears MSAccess is having a problem with the datatype designation. I am not supplying the length param since I believe this is only necessary for Text and Int datatypes.

Thanks in advance.

 

[jrbarnett]

ALTER TABLE tblANCILLIARY ADD COLUMN [ID] Counter

John

 

[PrgrmsAll]

Thanks. Perfect!