Create a table with an autonumber field with SQL (2003)

Topic

New Reply

I am used to using DAO for this sort of thing but in this project I need to use Jet SQL.
I am trying to make a table with an autonumber field and then set its validation rule to =1 ( so it can only ever hold one row)
Do I start with –
Create Table T0023([Pretender_ID] Long);

Reply | Quote

Replies

To create an AutoNumber field, use COUNTER or AUTOINCREMENT as field type:

CREATE TABLE T0023 (Pretender_ID COUNTER)

You cannot create a validation rule in SQL. You need DAO for that.

Reply | Quote

I’m trying to convince them to move to the DAO procedures I have written with your help.
thanks again

Reply | Quote