I am having issue on a consistent basis with some excel and access databases connected using a) Microsoft Query Wizard in Excel and b) Linked excel workbooks in Access.
Issue 1: A connection using Microsoft Query in Excel can be set up without any issues but modifying the connection a few days later becomes impossible. Even if I try to edit the SQL statement, it results in errors and never updates.
Issue 2: In Access 2007 with multiple linked workbooks and queries between them causes Access to stall and eventually crash. It all happens on a random basis and there is no specific task that it co sistently crash on, but it does crash very frequently.
Issue 3: Running a Query in Access with linked workbooks often opens the workbook in read-only mode and if another user on the server has the file open, it becomes very slow and often crashes.
A few other issues which end up slowing down the workflow or end up with a crashed application for both excel and access 2007.
I have tested the operation on another computer with office 2016 and I didn’t encounter any of the issues. I am wondering if there is an inherent issue in the Office 2007 that has been resolved in the later versions. Does anyone know if my assumption is correct that upgrading the office will resolve the connectivity issues between excel and access?
