Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    Unanswered: odbc call failed in ms access 2007


    I just finished the migration of one database from ms access 2003 to ms access 2007 but i have a problem. When I clicked on the "delete button" I'm getting this error:

    ODBC -call failed
    [Microsoft][SQL Server Native Client 10.0][SQL Server]
    The delete statement conflicted with the REFERENCE constraint "tblIndivMatMerk_FK00". The conflict occurred in database ewzEnergie, table "dbo.tblIndivMatMerk", column 'KursNR'. (#547)[Microsoft][SQL Server Native Client 10.0][SQL Server] The statement has been terminated. (#3621)

    does anybody have any idea why?
    what' strange is, if I clicked on the box and clicked again the "delete button" then it will ask me if I really would like to delete the record.
    But if I just click somewhere in the form then I'm getting this error.
    please help

    Attached Thumbnails Attached Thumbnails odbcfailed.png  

  2. #2
    Join Date
    Oct 2009
    delete & recreate that link from scratch

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    Sounds like you got a weird link setup - check your links and relationships and the ones that do and don't cascade delete. You can't delete a record if it's linked to another record and the cascade Delete is unchecked in the relational diagram (ie. it won't cascade delete and you'll get an error.) - you have to delete the record in the relational table first.

    If you've got multiple relationships setup, then look at each one which would affect the deleting and make sure you know what records in which tables need to be deleted BEFORE you delete the record you're trying to delete.

    An overly complex relational diagram will make finding this challenging so try to keep these simple.
    Last edited by pkstormy; 12-22-09 at 23:42.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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