Microsoft Access query based on linked tables from Sage 50 through ODBC crashing

SUGGESTED

Microsoft Access query based on linked tables from Sage 50 through ODBC crashing. MS Access just closes with no error messages and proposes to open in save mode next time around. Safe mode also crashes. I am using Sage 50 Quantum Accounting (Release 2023.1). Not sure if it has to do with the 32bit/64bit? I am using ODBC 64bit and MS Access 64bit? Any thoughts to diagnose the problem? Thanks everyone.

Parents
  • 0
    SUGGESTED

    Hi ,

    Thanks for reaching out. Did you ever find an answer for this issue? Do you have Anti virus running and perhaps blocking the file in 'C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE' from running via ODBC. 

    You could try to :

    1. Add MSACCESS.EXE (i.e. 'C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE) to exclusion list

    If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

    Warm Regards,

    Erzsi

Reply
  • 0
    SUGGESTED

    Hi ,

    Thanks for reaching out. Did you ever find an answer for this issue? Do you have Anti virus running and perhaps blocking the file in 'C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE' from running via ODBC. 

    You could try to :

    1. Add MSACCESS.EXE (i.e. 'C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE) to exclusion list

    If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

    Warm Regards,

    Erzsi

Children