autoincrement

[Taggi]

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?

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

Does only works in SQLServer.

Please... help me...

Taggi

[Taggi]

Sometimes ist good to have somebody to spek with.

OR... to change the words you use in your search...

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

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

Thanks!