What is the title error message telling me? As in, what’s wrong, where do I fix it?
It appears on refreshing Excel sheets pulling from Access queries, which have all worked for a few months.
What I did to cause this:
Yesterday I needed to update the contents of one field in one table. An Update Query per these MS instructions didn’t work—ie nothing happened when run, data didn’t update.
After a couple of fruitless hours, I implemented my fallback: downloaded the main table to Excel, updated the field in Excel, imported the sheet into a new table in Access, deleted the main table, and renamed the new table to the main table name. So:
‘Main’ to Excel;
‘Main1’ from Excel;
Delete ‘Main’
Rename ‘Main1’ to ‘Main’.
I’m not surprised this horsing around broke some connections between Access & Excel, but I don’t know which rabbit hole to jump down to fix it. SERPs on the error message seem to be all about SQL or Power Query/Pivot, None of which I’m using—just simple Select queries to present different views of the data.
I hope to avoid having to recreate all the queries again, or recreate all the sheets pulling from them.
Lugh.
~
Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 1TB SSD, 256GB SSD, 4TB HD
