Post reply

INSERT after DELETE from Access failing.

  • January 23, 2003 at 8:06 am

    #101359

    I'm currently trying to replace an existing Access back end db with a SQL 2000 db. The only problem I have hit (so far!) is when the client (another Access db with linked tables to the new SQL db) needs to replace a record.

    The VBA process DELETES the record and then INSERTS the new data. This is being done by locally executing SQL statements against the linked table.

    If the code is stepped through all works fine. When run normally the DELETE works but the INSERT hangs until failing with 3155 ODBC Insert Failed.

    Any suggestions/help?

  • January 23, 2003 at 8:35 am

    #447061

    Does the table have primary key?

  • January 23, 2003 at 10:39 am

    #447067

    Hi Allen

    Yes, there in a Primary Key, but that's all - no relationships, constrants or triggers are currently setup.

    The Table is even being read and updated in other places. It is just the INSERT after the DELETE - but only when run in VBA. If the SQL is run manually they both work 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply