On Office Update mdb file start firing the following erro OLE DB multi-step operation generated errors RRS feed

  • Question

  • I have a legacy mdb working on a client, that start given the following error(on the client)

    Give the following erro

    An error has occurred:
    OLE DB multi step operation generated errors. Check each value of
    OLE DB state, if available. No work done. -2147217887
    Microsoft Access Database Engine

    The code is:

    Dim Rs As New Recordset
    'this line give error
    Rs.Open "SELECT [ficha obra].*,Obras.distancia_obra AS ObrasDist FROM [ficha obra] LEFT JOIN Obras ON [ficha obra].n_obra = Obras.numero_obra WHERE n_obra = " & _
                numero_obra.Value & " AND [ficha obra].Data IS NOT NULL ORDER BY [ficha obra].Data,[ficha obra].matricula", CurrentProject.Connection

    The tables are in a second mdb.

    On a Windows 10 [Version 10.0.18362.418]  is working (sometimes fires but is very random and rare)

    On a Windows 7 (Client Computer) and Office 365 x86 always fire the error

    I try to update the Access engine but the problem continue

    Can you give me some tips?

    Thanks for you Help


    Joaquim Matos

    Monday, October 28, 2019 10:47 AM