changing column to autonumber

's Computer Specifications

Hi

How to change programatically column
from primary key to
autonumber?

Thanks
Konrad

's Computer Specifications

Konrad,

Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
properties of DataColumn

Stephen

"Konrad" <(E-Mail Removed)> wrote in message
news:bfc3i0$6b8$(E-Mail Removed)...
> Hi
>
> How to change programatically column
> from primary key to
> autonumber?
>
> Thanks
> Konrad
>
>

's Computer Specifications

What about changing column to autonumber
in existing database.

"Stephen Muecke" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Konrad,
>
> Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
> properties of DataColumn
>
> Stephen
>
> "Konrad" <(E-Mail Removed)> wrote in message
> news:bfc3i0$6b8$(E-Mail Removed)...
> > Hi
> >
> > How to change programatically column
> > from primary key to
> > autonumber?
> >
> > Thanks
> > Konrad
> >
> >
>
>

's Computer Specifications

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

"Konrad" <(E-Mail Removed)> wrote in message
news:bfd5fj$ark$(E-Mail Removed)...
> What about changing column to autonumber
> in existing database.
>
> "Stephen Muecke" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Konrad,
> >
> > Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
> > properties of DataColumn
> >
> > Stephen
> >
> > "Konrad" <(E-Mail Removed)> wrote in message
> > news:bfc3i0$6b8$(E-Mail Removed)...
> > > Hi
> > >
> > > How to change programatically column
> > > from primary key to
> > > autonumber?
> > >
> > > Thanks
> > > Konrad
> > >
> > >
> >
> >
>
>

's Computer Specifications

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

"Stephen Muecke" <(E-Mail Removed)> wrote in message
news:et#(E-Mail Removed)...
> 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
>
>
> "Konrad" <(E-Mail Removed)> wrote in message
> news:bfd5fj$ark$(E-Mail Removed)...
> > What about changing column to autonumber
> > in existing database.
> >
> > "Stephen Muecke" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Konrad,
> > >
> > > Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
> > > properties of DataColumn
> > >
> > > Stephen
> > >
> > > "Konrad" <(E-Mail Removed)> wrote in message
> > > news:bfc3i0$6b8$(E-Mail Removed)...
> > > > Hi
> > > >
> > > > How to change programatically column
> > > > from primary key to
> > > > autonumber?
> > > >
> > > > Thanks
> > > > Konrad
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I Return a selected row without the Frist column (ID autonumber column) ??	David Eadie	Microsoft ADO .NET	2	10th Apr 2005 09:13 AM
Changing the Value of an Autonumber	=?Utf-8?B?U2FtbXlhNjY=?=	Microsoft Access Getting Started	3	25th Feb 2005 03:15 PM
Changing Autonumber	=?Utf-8?B?c21ib3lk?=	Microsoft Access Forms	1	29th Dec 2004 03:31 AM
Changing Autonumber	Aurora	Microsoft Access Database Table Design	6	8th Jan 2004 07:33 PM
Changing primary key to autonumber	Jan H. DeGiorgio	Microsoft Access Database Table Design	3	31st Dec 2003 06:21 PM