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

Coverting linked tables into local tables 2
How to connect to a BE database? 0
Record-Locking remains open after closing 0
How to change Pivot Table external data source (MS Access Database)by VBA 0
Index with SQL Server Linked Tables 1
Runtime 2007 and Linked Table Manager 3
Acxess 2003 and 2007 1
Unlink and Relink 2

Top