Slow To Open with Linked Tables

P

Peter

I have Access 2000 database with 87 linked tables.
Everything works fine when I open the database with Access 2003
But when I try to open the same database with Access 2007 it takes several
minutes before the custom Form shows up. I have applied all of the services
packs to Acess 2007.

Does anyone know what could be causing the slowdown or how to fix it? A
database without any linked table opens up fast in Access 2007.
 
A

Alex Dybenko

Hi,
could be plenty of reasons, check - how underlying query opens, if you have
comboboxes loaded with lot of data - this could be reason, perhaps you have
code at form startup, etc. so try to find what exactly running slow

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 and Linked Tables 0
Embedded Excel into Word with Tables 0
Doughnut Chart linked with the slicer in the pivot table 0
Cell data entering slow! 0
Active Content in this file is blocked issue 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Shortcuts in OneDrive 0
Adding data to MS Access from csv file 0

Top