Hi,
I am required to import MS Access Database to generate report. I am using REMOTE VIEW to achieve this purpose. It work fine, however, I can't get Up-to-date Data when I use myremoteview. Instead, I need to requery everytime to refresh it before I can query it. It slow down my query from 20 secs (40,000 records) to 42 secs.

Any recommedation to optimise it?

Thank you