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