changing column to autonumber

K

Konrad

Hi

How to change programatically column
from primary key to
autonumber?

Thanks
Konrad
 
S

Stephen Muecke

Konrad,

Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
properties of DataColumn

Stephen
 
S

Stephen Muecke

Konrad,

Sorry, I assumed you meant a DataSet
If its a SQLServer database (or MSDE), you can use ALTER TABLE to make
changes to a table
Refer to SQL Server Books Online for help on this

Stephen
 
K

Konrad

Mainly I'am interested in Access database.
I read from sites that this is impossible.
Is it true?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top