AUTO NUMBER

[fu]

How do I set attribute property of a field to be "auto number" with SQL DDL?
Thanks

 

[Douglas J. Steele]

I'm not sure you can. I think you have to use DAO (or ADOX)

 

[Van T. Dinh]

ALTER TABLE Table1
Alter COLUMN ID COUNTER

ID is my Field Name. Tested OK in A2K2.