"jaYPee" <hijaypee@yahoo.com> wrote in message
news:8vl470phkea0fueivehemm3h882ousjg8f@4ax.com...
> I have a table in my sqlserver 2000 that has a field IDNO. i want this
> field to be my primary key. however i don't want this field to use the
> autoincrement feature. when i access this table from vb.net and try to
> add a record this field is autoincrementing. how can i disable the
> autoincrement of this field yet serves this as my primary key?
>
> thanks in advance

>> I have a table in my SQL Server 2000 that has a field [sic] IDNO. I

> Identity
> Identity Seed
> Identity Increment

"jaYPee" <hijaypee@yahoo.com> wrote in message
news:aos470d3p2gup57707rmeib2907453sn69@4ax.com...
> Thank you for the reply. however i can't find an autoincrementing
> properties under column properties in order to set it to false.
>
> under column properties of IDNO field i have i only see this
> properties:
>
> Description
> Default Value
> Precision
> Scale
> Identity
> Identity Seed
> Identity Increment
> Is RowGuid
> Formula
> Collation
>
> i presume before and until now that i have to set the identity to "no"
> but still in my vb.net app when i add record the IDNO field still
> increment to the last value + 1.
>
> don't know where can i set the autoincrement to "false"
>
> thanks again
>
> On Tue, 6 Apr 2004 09:41:21 +0200, "EricJ"
> <ericReMoVe@ThiSbitconsult.be.RE> wrote:
>
> >go to design, select your id make shure that there is a key symbol next
to
> >it (if not right click and set primary key)
> >this makes it the primary key the identity is something else -->
> >autoincrementing set it to false and there you go :)
> >
> >hope it helps
> >
> >eric
> >
> >"jaYPee" <hijaypee@yahoo.com> wrote in message
> >news:8vl470phkea0fueivehemm3h882ousjg8f@4ax.com...
> >> I have a table in my sqlserver 2000 that has a field IDNO. i want this
> >> field to be my primary key. however i don't want this field to use the
> >> autoincrement feature. when i access this table from vb.net and try to
> >> add a record this field is autoincrementing. how can i disable the
> >> autoincrement of this field yet serves this as my primary key?
> >>
> >> thanks in advance
> >
>

<ericReMoVe@ThiSbitconsult.be.RE> wrote:

>go to design, select your id make shure that there is a key symbol next to
>it (if not right click and set primary key)
>this makes it the primary key the identity is something else -->
>autoincrementing set it to false and there you go :)
>
>hope it helps
>
>eric
>
>"jaYPee" <hijaypee@yahoo.com> wrote in message
>news:8vl470phkea0fueivehemm3h882ousjg8f@4ax.com...
>> I have a table in my sqlserver 2000 that has a field IDNO. i want this
>> field to be my primary key. however i don't want this field to use the
>> autoincrement feature. when i access this table from vb.net and try to
>> add a record this field is autoincrementing. how can i disable the
>> autoincrement of this field yet serves this as my primary key?
>>
>> thanks in advance
>