Re: Row cannot be located for updating

From: Alverio (alverio.m_at_tiscali.it)
Date: 09/16/04

  • Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating" 
    Date: Thu, 16 Sep 2004 23:56:01 +0200

    Both primary keys in MasterTable and DetailTable are Autoincrement field
    (Long Integer type). IDMaster, the linking field in DetailTable, is also a
    Long Integer. If I set it to Integer, I cannot set the relationship in
    Access.
    But the problem seems to be on the Primary key fields, as they are not able
    to generate the proper increment value when I append a new record.

    "Brian Bushay TeamB" <BBushay@Nmpls.com> ha scritto nel messaggio
    news:id7jk0pj357qmu8pdr9kf3f53fhb5bt1hg@4ax.com...
    >
    > >I have a master table and a detail table. Relationship is between field
    ID
    > >(autoincrement field and primary key in MasterTable) and IDMaster
    (numeric
    > >field in DetailTable). DetailTable has an autoincrement field as primary
    > >key. The relationship is created in Access as well. I'm using
    >
    > The master linking field in the detail table needs to be of type Integer
    to link
    > to an Access autoincrment field.
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com

  • Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating"

    Relevant Pages

    • Row cannot be located for updating
      ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
      (borland.public.delphi.database.ado)
    • Re: Row cannot be located for updating
      ... >(autoincrement field and primary key in MasterTable) and IDMaster (numeric ... DetailTable has an autoincrement field as primary ... The master linking field in the detail table needs to be of type Integer to link ...
      (borland.public.delphi.database.ado)
    • Re: Search Form - Take 2
      ... While in Design mode, highlight all of the fields you want to include in the ... selected fields to the primary key. ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
      (microsoft.public.access.gettingstarted)
    • Re: Search Form - Take 2
      ... selected fields to the primary key. ... description column in Recommendations or Accomplishments you'll have some ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
      (microsoft.public.access.gettingstarted)
    • Re: Cannot add record for child table that have relationship with master table.
      ... If your tables don't have a relation in the database than you have to add ... Of course have you to create the master record first before you can add any ... detail table have a relationship with th master table with a primary key. ... because of datagrid will automatic add primary key relation to the master ...
      (microsoft.public.dotnet.framework.adonet)