Deleting a pass-through query - Access runs the query during the delete?

[MrJones1]

I have an Access application that generates and runs a lot of ODBC pass-through queries.

These queries accumulate in the application, and I periodically delete them. When I delete them, Access is running these pass-through queries. WTF? The queries are not open when I delete them, they are closed.



I've verified these queries are being run on the DB2 host when I delete them in Access.

For read only queries, this is not a huge problem. For update queries, this is a major problem. I don't want update queries running twice at points in time I don't expect.

Any idea how to get Access to stop running pass-through queries when I delete them?

[ranman256]

are you using: currentdb.Querydefs.delete "qsMyPassThruQry"

[MrJones1]

No. I'm just manually deleting them through the built-in Access user interface.

[MrJones1]

Did more experimentation. Apparently, if I perform a "Cut" of the query from the Custom or Object Type navigation pane, it runs the query as part of the "Cut" operation.

If I switch to the Object Type navigation pane, and perform a "Delete", it does not run the query during the delete.

So, solution found, but it doesn't make sense to me that a "Cut" of a query would run a pass-through query.