Slow To Open with Linked Tables

  • Follow


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.


-- 
Peter


Thank You
0
Reply Utf 12/2/2009 3:30:01 AM

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

"Peter" <Peter@discussions.microsoft.com> wrote in message 
news:179ABDD5-CEE8-49E9-9DCB-87A03B592D00@microsoft.com...
> 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.
>
>
> -- 
> Peter
>
>
> Thank You 

0
Reply Alex 12/2/2009 12:05:37 PM


1 Replies
929 Views

(page loaded in 0.043 seconds)

Similiar Articles:
















7/23/2012 3:24:04 PM


Reply: