Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Queries _ Query Quit Working

Posted by: dg_moore Nov 20 2019, 04:32 PM

I have a simple query that runs as part of an automated process. The query has been working flawlessly for about 2 years. Suddenly today when the query is launched the error 'Query " is corrupt' is displayed.

The query is used in two different procedures, with different tables:

UPDATE Payments SET Payments.DepositDate = #11/20/2019# WHERE (((Payments.DepositDate) Is Null));
UPDATE tbl_Attendees SET tbl_Attendees.DepositDate = #11/20/2019# WHERE tbl_Attendees.DepositDate Is Null And tbl_Attendees.LuncheonID = " & LnchId

and runs as SQL in a procedure.

I have tried running each as a standalone query with the same result. I have tried running it with different dates with the same result. I have recompiled, compacted and repaired the accdb with the same result.

The same error results when the app is run on 4 different workstations (all using the same backend data).

Any suggestions?

Posted by: theDBguy Nov 20 2019, 04:43 PM

Hi. Check out BLUF: Go to File > Account > Update Options > Update Now

Posted by: dg_moore Nov 20 2019, 05:03 PM

This just in from FMS:

A set of Microsoft Office security updates released on November 12, 2019 causes Access databases to fail when it runs Update Queries to modify data. ...It doesn't matter if the query is against a table in the current database, a linked table, or a linked SQL Server table. If the Access database engine is processing the UPDATE query, the error occurs.

We're running Office 365 and reportedly a solution is forthcoming soon, so we'll just wait a few days. Otherwise the only fix is to uninstall the security update.

Posted by: dg_moore Nov 20 2019, 05:04 PM

Yup, just saw this. Thanks

Posted by: theDBguy Nov 20 2019, 05:43 PM

Did you try the manual update?

Posted by: wislndixie Nov 21 2019, 10:15 AM

How would you do a manual update other than opening the table and going to each field in the table I want to update and changing the value? I have an update query that updates the "payperiod" to a number between 1-26. Everyone was on payperiod 25 and I tried to update to payperiod 26 but of course ran into the problem discussed in this thread. So is there an easy way to manually update all my "payperiod" fields to 26?

Posted by: cheekybuddha Nov 21 2019, 10:27 AM

Mike, did you check the thread linked in DBG's Post#2?

The manual update is for Access, not your table! wink.gif


Posted by: wislndixie Nov 21 2019, 10:40 AM

Yes, I just misunderstood and thought he was referring to updating the field in the table manually instead of adding or creating another query as discussed.

Posted by: theDBguy Nov 21 2019, 10:44 AM

Hi. Sorry if I wasn't clear enough. So, are you good to go now?