Re: Sql error Message



Guess 1. most likely you dont have a unique key in your recordset so that
the db engine cant tell for sure which row you want to update. Guess 2. It
could also mean the your data was changed by another usere since you
retrieved it from the db. If you are testing and getting this message it is
most likely guess no. 1.


.



Relevant Pages

  • Re: GetRows Method
    ... I told you that i dont want your help. ... I simply wanted intellgent answers from intellgent people. ... >> It moves the data from the recordset to the aVarray, ... > process data. ...
    (microsoft.public.vb.database.ado)
  • Re: GetRows Method
    ... I told you that i dont want your help. ... I simply wanted intellgent answers from intellgent people. ... > It moves the data from the recordset to the aVarray, ... The usual purpose of opening a recordset is to ...
    (microsoft.public.vb.database.ado)
  • Re: Locate Table
    ... No user will have direct access to the Id generating ... assign a unique key to a new entry in the data base. ... am profecient I will move on to the newer versions. ... >to this table in your procedure by defining a recordset ...
    (microsoft.public.access.gettingstarted)
  • Re: GetRows Method
    ... >> Hey Paul, can you spell looser? ... DUH is not such a harsh reply. ... recordset. ...
    (microsoft.public.vb.database.ado)
  • RE: Query to update records
    ... I dont have a primary or unique key that can identify a record from one list ... right and I would be copying emails to the wrong records! ... Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete ...
    (microsoft.public.access.reports)