When using MS Query in Excel to retrieve Access query data (both Office 2003) what causes active connections to become inactive ?
The only way to refresh them is to re-establish the connection to the Access query.
We have a workbook with multiple worksheets. Each worksheet has an MS Query connection to an Access query.
After refreshing, the MS Query connection on some of the worksheets is lost. But its erratic.
The only way to refresh them is to re-establish the connection to the Access query.
We have a workbook with multiple worksheets. Each worksheet has an MS Query connection to an Access query.
After refreshing, the MS Query connection on some of the worksheets is lost. But its erratic.
