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
|
|