none
Query " is corrupt Access bug also impacting ADODB recordset updates? RRS feed

  • Question

  • Hey all,

    I've been bitten in the behind by the recent security patch botch in Access, and I know that a solution is forthcoming for the problems with straight SQL updates with a where clause targeting a table.

    I've found another instance of the same issue, though, and wanted to see if it was generally known. When my program opens a dynamic ADODB recordset, updates values, and attempts to save, things go off the rails with the same error. I assume that under the hood, ADODB is just doing an update query on the database in this case, and hilarity ensues. It's doubly annoying because I can't exactly go in and alter the SQL syntax when it's hidden behind "RS.update".

    Somebody really screwed the pooch on this one.

    Anybody else seen this particular manifestation of this issue?

    thanks!

    Tuesday, November 19, 2019 2:45 AM

All replies