Auto number command ddl script access 2007

Asked By 30 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #134143

Auto number command ddl script access 2007

qa-featured
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.

Login/Register to Answer

Related Questions