Year 2009, Time for Access 2007?

[seaport]

Hi,

It's been one year after Access 2007 was released. My client wanted to migrate from Access 2000 to Access 2007, because the migration to Access 2003 seems to be a too-small step.

However, my application, with SQL Server 2005 as the backend, ran considerably slower in a Access 2007/vista machine than one a Access 2000/xp machine.

The Vista machine is the fastest one in the office (2.6GHz, qual core, 4gRam). Access 2007 SP1 has been installed.

Any idea or similar experience?

Below are some posts in 2007.

http://www.tek-tips.com/viewthread.cfm?qid=1336939

http://www.tek-tips.com/viewthread.cfm?qid=1433871

Seaport

 

[genomon]

We've had performance issues with Vista related to it's "enhanced" security features. Windows 7 is due soon.
I'd get rid of Vista and use XP for now.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[PHV]

Windows 7 is due soon
IMO windows 7 is nothing more than Vista SP2 ...

 

[seaport]

Hi,

My further investigation shows that the slowdown is due to Vista's ODBC connection rather than Access 2007. I tried two ODBC drivers (SQL Server and SQL Native Client). Either way the Vista's connection is slower than an XP machine.

Is there any way to speed up the connection? Right now the SQL server only allows TCP/IP connection. Will a named pipe speed up? Is there any security setting I can change?

Seaport