Forum Discussion
MS Access 2016 is not Responding when i open a Report or Table
Hi, When i open any Report or Table the Access 2016 is not responding. In Access File i have 4 Linked Tables and few Reports and Queries which i created based on the Linked Tables which are link...
Probably the linking to Excel is the culprit...to be certain make make table queries and create local tables out of the Excel and test again. Just yesterday i had a case with a rather small Excel as Linked table...it was literally crawling..making an Access table out of this just skyrocketted the performance.
- Thanks for the tip