Hello everyone,
I am using ODBC Data Source Administrator (64-bit) version 10.0.22621.1 to establish connection between Sage 50 Quantum Accounting (Release 2023.1) and Microsoft Excel 365 64bit and it works fine. When I use the ODBC to import tables (unlinked) into Microsoft Access 365 64bit it also works well. When I create linked tables between Sage 50 and Microsoft Access this also works well. The issue is when I run queries based on these tables, Microsoft Access crashes immediately.
I was told that I need to use Microsoft Access 32bit to fix this however I am skeptical because first the connection works perfectly well with Microsoft Excel which is a 64bit version and second, my understanding is that my Sage 50 is 64bit, the ODBC is 64bit and the Microsoft Access is 64bit so they are all operating at the same 64bit version therefore should be compatible.
Thanks for any guidance you can provide.
Marc