Create Table in Access with autoincrement field

[Marcus_Körner]

Hello,

I like to create a new table in an access database. 

The problem is to create an ID field with autoincrement. I can add "not null" and "primary key" to the field but not the "autoincrement" option.

Do you have a solution for that problem?

Thank you

Marcus

[Ranjeet_Singh]

Field i.e. new record or new column?

[Marcus_Körner]

Hi Ranjeet_Singh,

thanks for your replay.

I create a new table with a new column called "ID" which schoud be "autoincrement".

The records will be added later.

[Dennis_Knutson]

Isn't that a question for Microsoft, the Access help, or a simple google search?

[Ranjeet_Singh]

Through SQL you can change the column name I think.

Just google the topic

[Marcus_Körner]

I think it is a problem with the Database Connectivity Toolkit (DCT).

I changed from the ADO Toolkit (http://www.ib-berger.com/index.php?action=adotool) to the DCT.

With ADO it worked fine. But I have to change the code to the DCT. Actually most thinks are working but the autoincrement makes the only problem.

The Picture shows the code of creation.

Hope you can help me. 

It is no option to create the tables manually.

Thanks for your help.

[Ranjeet_Singh]

May be but this is also because all database providers not provide all the functionality. 

[Ranjeet_Singh]

Here must be an option to read the current primary key number. Search

[Yamaeda · Accepted solution]

Access autoincrement

It seems that if the Autoincrement doesn't work you can try Counter as column specification.

/Y

[Ranjeet_Singh]

Hope this helps him. Good job