AUTO NUMBER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set attribute property of a field to be "auto number" with SQL DDL?
Thanks
 
I'm not sure you can. I think you have to use DAO (or ADOX)
 
ALTER TABLE Table1
Alter COLUMN ID COUNTER

ID is my Field Name. Tested OK in A2K2.
 
You must log in or register to reply here.

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

Auto fill not working 2
MS Access problem 0
Auto number in an existing table 4
The next Grand Theft Auto title has been officially announced 0
How to add a new field for existing table programmatically ? 14
changing start value in the auto number 4
auto number in query 1
Auto numbers 2

Back
Top