Upgrade Access 2003 application to Access 2007

[Janis in Minnesota]

We have written an application using Access 2003 that is fast and works great.

We have loaded Access 2007 on a Vista platform, computer is intel xeon
processor with 2 gig memory. We moved our application to this computer and
upon opening our mdb, we have a query parameter that pops up (EntryID) twice,
and then FINALLY opens up the main form.

Clicking on the left Office Button takes about 30 seconds.

Actually, everything about 2007 seems really slow.

Our application has a lot of code - and it seems from some of the
information in the discussion group that this may be a problem?

We have trusted all of our folders for now, and we are not sure where to go
from here.

Any advice would be greatly appreciated!

Thanks in advance!!!

 

[Sascha Trowitzsch]

Hi,

Performance problems when opening mdbs in A2007 have been reported by many other
developers, but as far as iI know, there's no solution yet, because a mostly not
reproduceable behaviour. I have the same problem with some mdbs but couldn't
figure out what the reason is.

Concerning the slow reaction when clicking the office button for the first time:
This seems to be related with the strange circumstance, that Access enumerates
*all* fonts in system and registry. I noticed that when logging with a registry
monitor to see which keys Access is accessing on startup. Clicking the office
button starts this enumeration procedure and wents through all the hundereds of
registered fonts. I don't know what this is good for..

Sascha