Answered by:
AceDao - problem with requery

Question
-
Hi,
After actualize MS OFFICE 365 (Version 2008 Build 13127.20208) is new version of acedao.dll (registreted in
system in c:\Program Files (x86)\Microsoft Office\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\ACEDAO.DLL).
Now the program crashes when using the function "Requery" or "raw_Requery".
Older version of Acedao.dll was from "Access Databaze Engine 2016"
(c:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL) is OK.
Exception number: C0000005 ACCESS_VIOLATIONvoid CsDaoRecordset::Requery() { ASSERT_VALID(this); ASSERT(IsOpen()); ASSERT(CanRestart()); // If filter or sort strings changed, must Close and Open // This is only effective if m_strFilter/m_strSort used if (((m_pQueryDef != NULL) && (m_nStatus & AFX_DAO_IMPLICIT_QD)) && ((m_strRequeryFilter != m_strFilter) || (m_strRequerySort != m_strSort))) { Close(); Open(m_nOpenType, m_strRequerySQL, m_nOptions); } else { // Rebind parameters in case values have changed //BindParameters(); if (m_pQueryDef != NULL) { COleVariant varDisp; varDisp.pdispVal = m_pQueryDef->m_pDAOQueryDef; varDisp.vt = VT_DISPATCH; TRY { // there is a problem DAO_CHECK(m_pDAORecordset->raw_Requery(varDisp)); } CATCH_ALL(e) { // Reset vt to prevent release of DAOQueryDef varDisp.vt = VT_EMPTY; THROW_LAST(); } END_CATCH_ALL // Reset vt to prevent release of DAOQueryDef varDisp.vt = VT_EMPTY; } else { // Must be a table type recordset (this will fail!) DAO_CHECK(m_pDAORecordset->raw_Requery(/*_afxOptionalVariant*/)); } GetDataAndFixupNulls(); } }
Could you help me?
- Edited by Zdenek_01 Wednesday, August 19, 2020 9:13 PM
Wednesday, August 19, 2020 9:12 PM
Answers
-
Hi,
There have been changes to Office 365 so that when using DAO interfaces, you will now communicate with the version of Ace shipped with O365, rather than the version shipped with the Access Database Engine Redistributable, as you've noted.
So, the short term workaround to avoid this issue is to reinstall the Access Database Engine Redistributable, and then run your program. This will allow you to use the older version of Ace, although you will need to repeat this after new O365 updates.
We will investigate the issue based on your report, but if possible it would be helpful to see your entire program/database to reproduce the problem. If you use the feedback tool in Access (Help/Feedback) to report the issue, and include your email address, then we can share more that way.
Shane Groff
Access EngineeringShane L. Groff (Microsoft Engineer)
- Marked as answer by Zdenek_01 Monday, August 24, 2020 3:20 PM
Thursday, August 20, 2020 4:05 PM -
I tested lates version of Office Current Channel (Preview), Version 2008 (Build 13127.20378), September 04, 2020 and it is OK.
Thank you.Zdenek
- Marked as answer by Zdenek_01 Monday, September 14, 2020 10:06 AM
Monday, September 7, 2020 10:54 AM
All replies
-
Hi,
There have been changes to Office 365 so that when using DAO interfaces, you will now communicate with the version of Ace shipped with O365, rather than the version shipped with the Access Database Engine Redistributable, as you've noted.
So, the short term workaround to avoid this issue is to reinstall the Access Database Engine Redistributable, and then run your program. This will allow you to use the older version of Ace, although you will need to repeat this after new O365 updates.
We will investigate the issue based on your report, but if possible it would be helpful to see your entire program/database to reproduce the problem. If you use the feedback tool in Access (Help/Feedback) to report the issue, and include your email address, then we can share more that way.
Shane Groff
Access EngineeringShane L. Groff (Microsoft Engineer)
- Marked as answer by Zdenek_01 Monday, August 24, 2020 3:20 PM
Thursday, August 20, 2020 4:05 PM -
Thank you for you answer.
If I reinstall AceDao redistributable, it's OK.
If I reinstall Office 365, the program crashes.I am sending example.
acedaoRelease.zip
0,53 MB
acedaoSource.zip
128,16 MB
http://www.stormware.cz/podpora/get.aspx?id=6e3d1bf6-e2aa-4ecd-8268-f0fa897afd89
Zdenek
Tato zpráva je uložená na adrese:
Monday, August 24, 2020 5:34 PM -
Thanks. I see the issue you are encountering, and am working on addressing the issue.
In the meantime, I'm glad to hear that reinstalling the redistributable worked for you.
Shane Groff
Access EngineeringShane L. Groff (Microsoft Engineer)
Monday, August 24, 2020 10:19 PM -
I tested lates version of Office Current Channel (Preview), Version 2008 (Build 13127.20378), September 04, 2020 and it is OK.
Thank you.Zdenek
- Marked as answer by Zdenek_01 Monday, September 14, 2020 10:06 AM
Monday, September 7, 2020 10:54 AM -
Thanks for confirming that the update fixes the issue for you.
Please let us know if you see any further problems.
Shane
Shane L. Groff (Microsoft Engineer)
Monday, September 7, 2020 7:44 PM