Auto number command ddl script access 2007

Asked By Sandra Teylor 30 points N/A Posted on - 02/06/2013

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.

• Status: Open
• Question Views: 907
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Drake Vivian 30 points N/A #134143

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.

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 02/28/2013
• Question Category: MS Access