Re: Catch duplicate primary key exeption

Thanks,
It is a key like social insurance ID.
It will be keyin by user.

<hashimisayed@xxxxxxxxx>
???????:1118082382.232840.324930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> How is the primary key created? Is it auto generated? If so, you
> wouldn't have this problem, so I am guessing that you are generating it
> yourself. Can you tell us how the key is generated? You also need to
> tell us how you are doing the insert? Is all of this done in code,
> i.e., do you create a key in code and then try to do an insert? Or do
> you use stored procedures for all of this? Tell us a little bit more...
>
> sayed
>


.

Relevant Pages

  • Re: auto number vs byte
    ... > beginning I designed the primary key to be number ... > instead of auto number in order to save on resourses and ... > lot more difficult in programming compared to auto number. ... > a more complex routine to handle addition of new items ...
    (microsoft.public.access.formscoding)
  • RE: crosstab or looping statement help
    ... number can appear in multiple counties). ... The primary key is an auto ... The other table (tReview) has another auto number primary key with ...
    (microsoft.public.access.reports)
  • Re: Form Save
    ... You calculate the new value for this Primary Key in the Before Update event ... they get the same calculation. ... Auto Number ... Increment number ...
    (microsoft.public.access.modulesdaovba)
  • Re: auto number vs byte
    ... Now, in terms PK storage, this translates to 256 bytes per table ... > beginning I designed the primary key to be number ... > lot more difficult in programming compared to auto number. ... > a more complex routine to handle addition of new items ...
    (microsoft.public.access.formscoding)
  • Re: auto number primary key
    ... Can I import data in to a table with auto number primary key? ... "Jeff Boyce" wrote: ... primary key of the "one" side table, and you'd need to add a LongInt field ...
    (microsoft.public.access.tablesdbdesign)