Windows MS Access Delete Query: linked MySQL table

Discussion in 'Software' started by OneSeventeen, 28 Jan 2006.

  1. OneSeventeen

    OneSeventeen Oooh Shiny!

    Joined:
    3 Apr 2002
    Posts:
    3,454
    Likes Received:
    2
    I've got a database that has a linked MySQL table in it (via ODBC) and if I try to delete a row, it appears as though it is deleted, but when I close and reopen the table, the data is still there.

    On top of that, every DELETE query I run returns with an ODBC -call failed.

    When I use the exact same ODBC connection with OpenOffice.org 2.0 delete queries work perfectly, but since we have to work with people who don't have (and don't want to have) OpenOffice.org 2, we've got to figure out what's up with Access.

    Any tips?
     
Tags:

Share This Page