Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Question Unanswered: Delete a record on a Join rs with ADO

    I have to edit or delete a record of the side "one" of a join.

    DAO simply edits or deletes the record of the main table. With ADO, i get an error ("no information for key column"). Can I set an option, or something like that, to let ADO knows the main table ?

    The only workaround I found is to find that record on another recordset (just the main table); edit or delete it; refresh the join recordset. I'd rather do on the join recordset itself.

    Many thanks in advance.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Which database are you using ? What is your original query that creates the recordset ?

  3. #3
    Join Date
    Nov 2003
    Posts
    5
    I have this problem with Access 2000 and with SQL Server. I'm pretty sure it's an option to set on the ADO recordset...

    The join is a classical inner join between two tables (main/detail).

    Thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •