Slow response in Access to SQL in Windows 7

[OnTheFly]

I have a working application written in Access 2000 that has a SQL database back end. The tables are linked SQL tables. It works fine in Access 2000-2003 when on a WindowsXP OS. However, when a computer is updated to Windows 7 OS the response time to do filters and queries on the forms is dirt slow. What would normally take about a couple of seconds now takes 10-20 seconds. This also happened with Vista, although we no longer have anyone on Vista.

I have no clue where to begin to debug this issue. The connection to the SQL server through the ODBC setup seems to be fine and is not sluggish at all.

Anyone else run into this? And if you have, have you found a solution?

Hope this helps.

OnTheFly

 

[jrbarnett]

Which version of Access are you running on windows 7?

John

 

[OnTheFly]

Access 2003

Hope this helps.

OnTheFly

 

[jrbarnett]

I would hope with the same database and server and the same account for authentication that this would be identical but one way to check if it is doing something different is to run SQL profiler against a query on windows xp, and again on windows 7 and compare the results.

Another approach would be to look at the PC itself - is it a decent spec PC for XP but base level for Windows 7 (not a lot of RAM etc)?
What else is running on the PC at the same time?
If there are network performance issues that will also affect things, likewise connectivity to the domain controllers if you are using active directory authentication to access the databases.

John

 

[jsteph]

Is it 64-bit Win7?

I've noticed some delays because 32-bit programs run on a realtime emulator in win7 64-bit. The delays I've noticed aren't huge nor are they deal breakers, but they do exist.

However, in my situation I'm comparing a different machine--my Win7 machine is brand new and significantly more powerful than my old winxp machine, so if comparing apples there may be quite a difference due to the 32 bit emulator.
--Jim

 

[OnTheFly]

There are actually 2 PCs in question. The first is fairly new but started with Vista and then was upgraded to Win 7. The other machine is brand new and came with Win 7. I am not sure on the 32 bit vs. 64 bit but I can check that out.

I was wondering if maybe it is a conflict of some sort with Win 7 and SQL Server 2005?

Although I do have another Access application running off of SQL and it does not have the same issues but it is an adp application and it does not do as much in the way of filtering and querying.


Hope this helps.

OnTheFly

 

[jsteph]

At work I have a Windows 2005 64-bit server on Win2003 64-bit, I have a Sql2000 on Server 2003 (32 bit) and sql-2008 on server 2008 32-bit, and I can have linked tables from all three servers in a single Access db on either a Windows XP machine or Windows 7 64-bit. So there should be no incompatibilities.

I do see an hourglass for a tad more than I'm used to when opening Access forms, etc, in Win7, but like I said that's the emulator lag.
--Jim