Oct 24, 2006 #1 Gigatech Programmer Joined Jul 12, 2000 Messages 80 Location CR Hi, I´m trying to create a table on runtime. I use Access 2000 with ADO. I use the sql command: create table mytable ( id INTEGER, name VARCHAR(50)) , and it works fine, but how can I define an autoincremental field ? thanks
Hi, I´m trying to create a table on runtime. I use Access 2000 with ADO. I use the sql command: create table mytable ( id INTEGER, name VARCHAR(50)) , and it works fine, but how can I define an autoincremental field ? thanks
Oct 24, 2006 Thread starter #2 Gigatech Programmer Joined Jul 12, 2000 Messages 80 Location CR I solved the problem. I use COUNTER type. Thanks Upvote 0 Downvote