autoincrement

Hallo!

I am using a ACCESS datebase and try to create a table with an unique autoincrement column. I habe found many examples for SQLServer, but nor for ACCESS. Does any knows?

Code:

---

CREATE TABLE myTable (ID integer default autoincrement primary key, name varchar(30))

---

Does only works in SQLServer.

Please... help me... ;)

Taggi

Sometimes ist good to have somebody to spek with. :blush:

OR... to change the words you use in your search... :blush: :D

For ACCESS with C# and SQL-Statement it has to be:

Code:

---

CREATE TABLE myTable (ID COUNTER primary key, name varchar(30))

---

:wave: Thanks!