CODEWITHSUNDEEP
sqlvb.netms-access
user1570048
user1570048

Reputation: 880

VB.NET MDB creating a table command and Autonumber type

i am using the following command to create a table in an mdb database, it works fine when i remove the autonumber type

"CREATE TABLE pxs(sid Autonumber , Adress Text , Port Text, user Text, pass Text, sreq Integer, freq Integer)"

so how should i define an id column as autonumber?

Upvotes: 1

Views: 1209

Answers (1)

Fionnuala
Fionnuala

Reputation: 91326

You can use:

CREATE TABLE pxs(sid counter primary key, ...

Note that user is a reserved word, so you might like to use some other name.

Upvotes: 2

Related Questions