Re: Auto numbering in ADO
IDENTITY is called COUNTER in access:
use something like :
Code:
Create table ABC(MyID COUNTER primary key )
Re: Auto numbering in ADO
I already tried that but didn't work. I get a sql syntax error. I found out that if I made the primary key a long then it worked. Don't know why but it does.
Thanks for your reply,
Wayne
Re: Auto numbering in ADO
Hi
this works great in Access XP:
Code:
CREATE TABLE League (ID counter PRIMARY KEY,
LeagueName Text,
BowlingCenter Text)
What version of access do you use ?
Do you get any Error messages ?
Re: Auto numbering in ADO
The problem is I don't have Access. Wish I did. Had to do it all with ADO and SQL.
Thanks anyway,
Wayne