The program creates a table for the Access database, one of which is an automatic number type.

Using system;
Using ADOX;

...
String dbname = "C: // mymdb. mdb ";
ADOX. catalogclass cat = new ADOX. catalogclass ();
Cat. Create ("provider = Microsoft. Jet. oledb.4.0; Data Source =" + dbname + ";");
Console. Write ("Database:" + dbname + "already created! ");
ADOX. tableclass TBL = new ADOX. tableclass ();
TBL. parentcatalog = cat;
TBL. Name = "mytable ";

// Add an Automatically increasing field
ADOX. columnclass Col = new ADOX. columnclass ();
Col. parentcatalog = cat;
Col. type = ADOX. datatypeenum. adinteger; // you must set the field type first.
Col. Name = "ID ";
Col. properties ["jet oledb: Allow zero length"]. value = false;
Col. properties ["autoincrement"]. value = true;
TBL. Columns. append (COL, ADOX. datatypeenum. adinteger, 0 );

// Set the primary key
TBL. Keys. append ("primarykey", ADOX. keytypeenum. adkeyprimary, "ID ","","");
Cat. Tables. append (TBL );

Console. Write ("
Database Table: "+ TBL. Name +" already created! ");
TBL = NULL;
Cat = NULL;