Re: primary key autoincrement question.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: EricJ (ericReMoVe_at_ThiSbitconsult.be.RE)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 09:41:21 +0200

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

Relevant Pages

  • Re: Can and Cant insert using DAO on SQL Server linked table
    ... is set to Yes for the Primary Key which is autoincrementing. ... Mark ... >> God Bless, ...
    (microsoft.public.sqlserver.security)
  • Re: Strange problem
    ... 150 records in it, with an autoincrementing ... >id-field, called ArchiveID as the primary key. ... If you are using a TadoTable set the Indexname to the index of your Primary key ...
    (borland.public.delphi.database.ado)
  • Re: primary key autoincrement question.
    ... properties under column properties in order to set it to false. ... but still in my vb.net app when i add record the IDNO field still ... >it (if not right click and set primary key) ... >autoincrementing set it to false and there you go:) ...
    (microsoft.public.dotnet.languages.vb)
  • Re: unique composite key
    ... You can now create a composite index. ... Microsoft Access MVP ... property of table and set primary key to set my compsite key. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: unique composite key
    ... You can now create a composite index. ... property of table and set primary key to set my compsite key. ...
    (microsoft.public.access.tablesdbdesign)