Windows 7 / MS-Access 2007

[Kernel]

Hi Out there
I have an application with a form and subforms presenting orderlines.

The front end is MS-Access and the back-end (data) is SQL-Server 2005.
I'm using ODBC connections.

I takes normally 3 seconds to open the form (which is rather complex) when the client is Windows XP/MS-Access 2003.
With Windows XP/MS-Access 2007 i takes 4 seconds.
With Client Windows 7/MS-Access 2007 it takes 18 seconds.

I have also a PC running Windows 7 and with an SQL-Server 2005.
I have run the application on that PC with a sample of the database (eliminates the network).
When using MS-Access 2003 it took 3 seconds to open the form.
With MS-Access 2007 it took 45 seconds.

It seems to me that it is the combination Windows 7/MS-Access 2007?? Or??

Have anyone any knowledge if there is a problem with Windows 7/MS-Access 2007/SQL-Server ODBC connections?

Thank You
Peter Kernel

 

[Vassago]

Hi Out there
I have an application with a form and subforms presenting orderlines.

The front end is MS-Access and the back-end (data) is SQL-Server 2005.
I'm using ODBC connections.

I takes normally 3 seconds to open the form (which is rather complex) when the client is Windows XP/MS-Access 2003.
With Windows XP/MS-Access 2007 i takes 4 seconds.
With Client Windows 7/MS-Access 2007 it takes 18 seconds.

I have also a PC running Windows 7 and with an SQL-Server 2005.
I have run the application on that PC with a sample of the database (eliminates the network).
When using MS-Access 2003 it took 3 seconds to open the form.
With MS-Access 2007 it took 45 seconds.

It seems to me that it is the combination Windows 7/MS-Access 2007?? Or??

Have anyone any knowledge if there is a problem with Windows 7/MS-Access 2007/SQL-Server ODBC connections?

Thank You
Peter Kernel

Could it be the processing power of the computers? Maybe the WIndows 7 pc doesn't have enough power or memory to run Windows 7 and process data as fast as the XP machine.

 

[boblarson]

Actually it can be hard to diagnose, but a lot of times it is how you are opening recordsets (i.e. forms, combo boxes, etc.) and when. And, some things have changed in 2007/2010 so you might need to optimize for them. I don't have any suggestions off-hand, but make sure you have all service packs installed for 2007 as that was an issue with the initial release and SP1 helped and I think SP2 may have helped some more.

 

[Vassago]

I know that when we upgraded our machines from XP/2003 to 7/2010 and got new machines, I saw a huge improvement on the speed of our databases, so I'm really thinking hardware here. You haven't really given us enough details to determine though.