Creating tables with autonumber/primary key

[Vsn]

Hello all,

Could someone help me on the simplest function to create a table including a
field which numbers automaticly and is the primary key. It would help me a
lot.

Many thanks,
Ludovic

 

[estewart]

In the table design make the data type AutoNumber. Then
select that line (highlight it) then press the Key button
in the toolbar.

 

[Vsn]

Thanks for the advice, but I was actualy looking for code to do the same.

Thx

 

[Tom Wickerath]

Hello Ludovic,

Try one of the following KB articles:

Using DAO
Create and Drop Tables and Relationships Using SQL DDL
http://support.microsoft.com/?id=291539

Using ADOX
ACC2000: How to Create a Table with Jet Data Types via ADOX
http://support.microsoft.com/?id=275252


Tom
__________________________________________


Thanks for the advice, but I was actualy looking for code to do the same.

Thx
__________________________________________


In the table design make the data type AutoNumber. Then select that line (highlight it) then
press the Key button in the toolbar.
__________________________________________


Hello all,

Could someone help me on the simplest function to create a table including a field which numbers
automatically and is the primary key. It would help me a lot.

Many thanks,
Ludovic

 

[Vsn]

Tom, thanks alot for the advice, the second link you gave did help me out.

Ludovic