Making a DAO Autonumber field in new table 1

[GIJoeFigure]

I have VBA code that makes a Tabledef if its name doesn't already exist in the database and adds it to my other tables, but I wish to set its ID field to Autonumber (Long). Any ideas as to how to do this?

Thanks

 

[GIJoeFigure]

I forgot to add that I'm using Access 2000 and I know its easy to create an autonumber field but I was hoping that you can set one up while appending fields to a tabledef

 

[PHV]

You may do it with DDL:
DoCmd.RunSQL "ALTER TABLE yourTable ADD COLUMN myID COUNTER(1,1);"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GIJoeFigure]

PHV, you've done it again!! So many times you've helped me. Thanks. One last thing, is it possible to move the column to be the first in the table because it shows up last in the table after being added on by the sql.

 

[PHV]

In relational database the order of table columns is irrelevant as it is the select list that determines the order of the columns returned by the query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244