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_VIOLATION 

void 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?

Answer 1

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 Engineering

---

Shane L. Groff (Microsoft Engineer)

Answer 2

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	Stáhnout
acedaoSource.zip	128,16 MB	Stáhnout

 http://www.stormware.cz/podpora/get.aspx?id=6e3d1bf6-e2aa-4ecd-8268-f0fa897afd89

Zdenek

Tato zpráva je uložená na adrese:

Answer 3

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 Engineering

---

Shane L. Groff (Microsoft Engineer)

Answer 4

I tested lates version of Office Current Channel (Preview), Version 2008 (Build 13127.20378), September 04, 2020 and it is OK.
Thank you.

Zdenek

Answer 5

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)