Creating tables with autonumber/primary key

  • Thread starter Thread starter Vsn
  • Start date Start date
V

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
 
In the table design make the data type AutoNumber. Then
select that line (highlight it) then press the Key button
in the toolbar.
 
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
 
Back
Top