query speed

  1. bs0d

    Linked Table Speed - ADO Active Connection in VBA

    I have an Excel application that uses ADO to query an Access database with linked tables from numerous other Access databases. I've noticed the speed of the queries has slowed down with the number of records increasing each day. This has prompted me to explore optimization ideas where I came...
    • bs0d
    • Thread
    • ado connection linked tables query speed
    • Replies: 6
    • Forum: Microsoft Access
  2. S

    Queries running very slow

    Was able to run same queries in the past and they use to run fast but recently it is taking hell lot of time to run. Any idea to improve the execution time? Do I need to clear memory or do something else? Thanks Sachin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top