Hi there! Making my program using Access. I have some issue on how making an auto number ddl script access 2007 Edition. What command should I use? Thanks guys indeed.
Auto number command ddl script access 2007
Hello Sandra,
Â
There are 3 different ways to generate autonumbers in Access. The data type you need is called Counter and numbers can be generated as start value plus increment, random numbers or replication IDs.
Â
To create an autonumber field with a start value plus the increment you should use the following DDL query:
Â
CREATE TABLE Table1 (
  Field1 COUNTER ([beginning_number], [increment_number]),
  […]
);
Â
Â
Hope this helped.
