Access 2007 with Vista performance slow

[Charax]

I have Access 2003 on a Win XP Pro SP2 desktop (512 MB RAM) and SQL Server
2000 database (50,000 records).

I also have Access 2007 on a Vista Home Premium laptop (1 GB RAM); SQL
Server 2005 installed with identical db.

My primary app is an Access 2003 mdb front end with ODBC links to SQL Server
which runs like a scalded cat on Win XP whether linked to the SQL Server
2000 or the SQL Server 2005. But when I run the mdb with Access 2007 on
Vista, it is sooo doggy that it is unusable. Like 3-4 minutes for record
navigation! Doesn't matter whether linked to the SS2000 or the SS2005 db.

I have removed user level security, rechecked all the VBA references are
correct and recompiled under A2007/Vista. But no improved performance at
all. I tried turning off Symantec anti-virus and firewall - no help.

Other Office 2007 apps on the laptop run quickly. Can someone suggest some
approaches to troubleshooting this Vista-A2007 performance problem?

Thanks in advance,

Charax

 

[aaron.kempf]

yeah; don't use linked tables-- use Access Data Projects

 

[Charax]

The story continues. The slow connection to SQL Server databases using ODBC
from Access 2007 on a Vista laptop drove me to finally remove A2007 and
install Access 2003.

A2003 connects reliably to SQL Server 2000 database on another machine (Win
XP Pro SP2) and runs very fast, but A2003 on Vista cannot achieve reliable
connection to SQL Server 2005 on the same laptop. Symptoms are slow to link,
then only small tables (<200 records) can be opened. Large tables (50,000
records) start to open, then get an ODBC time out error after a long wait.

Help! Can anyone suggest what is wrong?

 

[wpowell]

I've been experiencing the same poor performance with A2007 and
Vista. It's practically unusable.

 

[Charax]

Glad to have confirmation it isn't just my installation. Unfortunately, I'm
on a road trip and unable to use my database and only have access to slow
dial-up connections.

Are you using SQL Server 2005 and A2007 on the same computer? (Mine is an HP
laptop with Vista Home Premium).

I uninstalled A2007 and reinstalled A2003 but am still having very slow
performance, perhaps indicating an SQL Server issue, not just A2007.

Cheers,

Charax

 

[Charax]

There is a new twist to my problems with Access performance on Vista, and
perhaps someone can direct me toward a solution based on these new clues.

I'm on a long trip with my laptop and intermittently connect to the Internet
by dial-up. I've discovered by chance that:

(1) if I restart Vista and do not connect to the Internet, the Access front
end will properly ODBC link to the SQL Server 2005 back end on the laptop
and run very fast so long as I do not connect to the Internet.

(2) if I restart Vista and connect by dial-up to the Internet BEFORE
starting Access, the slow linking to SQL Server and subsequent abominable
performance occurs, and Access remains unusable even after disconnecting
from the Internet.

(3) if I restart Vista and connect by dial-up to the Internet AFTER starting
Access, performance is OK for varying amounts of time before performance
degrades and Access becomes unusable.

So -- is it a network protocol issue of some sort? What changes when an
Internet connection is made that will inhibit ODBC links to the SQL Server
back end?

[At home before departing on the trip, the laptop was always connected to my
wireless network before Access was started. I now realize that some
networking issue may have been causing the persistent bad performance since
I did all troubleshooting while connected to the wireless network.]

UAC is turned off and Access is run as administrator. Turning off the
firewall and virus protection are of no help.

Thanks for any insight to this problem.

Charax

 

[Tony Toews [MVP]]

There is a new twist to my problems with Access performance on Vista, and
perhaps someone can direct me toward a solution based on these new clues.

Very interesting. I'd suggest reposting into the
access.odbcclientserver newsgroup as there are some folks who hang out
there who are much more familiar with SQL Server.

Or try a new posting with a new subject mentioning ODBC and SQL Server
2005. That'll get the right folks more interested in looking at your
problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[DAVID]

Vista has some known problems in the IP stack, due
to windowing behaviour. Perhaps this is causing the
problems? Sorry I don't have a URL, but what happens
if you turn the TCP/IP windowing to strict?

(david)

There is a new twist to my problems with Access performance on Vista,
and perhaps someone can direct me toward a solution based on these new
clues.

I'm on a long trip with my laptop and intermittently connect to the
Internet by dial-up. I've discovered by chance that:

(1) if I restart Vista and do not connect to the Internet, the Access
front end will properly ODBC link to the SQL Server 2005 back end on the
laptop and run very fast so long as I do not connect to the Internet.

(2) if I restart Vista and connect by dial-up to the Internet BEFORE
starting Access, the slow linking to SQL Server and subsequent
abominable performance occurs, and Access remains unusable even after
disconnecting from the Internet.

(3) if I restart Vista and connect by dial-up to the Internet AFTER
starting Access, performance is OK for varying amounts of time before
performance degrades and Access becomes unusable.

So -- is it a network protocol issue of some sort? What changes when an
Internet connection is made that will inhibit ODBC links to the SQL
Server back end?

[At home before departing on the trip, the laptop was always connected
to my wireless network before Access was started. I now realize that
some networking issue may have been causing the persistent bad
performance since I did all troubleshooting while connected to the
wireless network.]

UAC is turned off and Access is run as administrator. Turning off the
firewall and virus protection are of no help.

Thanks for any insight to this problem.

Charax

Glad to have confirmation it isn't just my installation.
Unfortunately, I'm on a road trip and unable to use my database and
only have access to slow dial-up connections.

Are you using SQL Server 2005 and A2007 on the same computer? (Mine is
an HP laptop with Vista Home Premium).

I uninstalled A2007 and reinstalled A2003 but am still having very
slow performance, perhaps indicating an SQL Server issue, not just A2007.

Cheers,

Charax

 

[Charax]

Thanks Tony. Will do as you suggest.

Cheers,

Charax

 

[Charax]

David, where does one find the strict setting for TCP/IP (using Vista Home
Premium)?

Cheers,

Charax

 

[DAVID]

http://support.microsoft.com/kb/929868

http://support.microsoft.com/kb/935400

http://www.neoblog.co.uk/?p=13

 

[Charax]

Many thanks for the leads.

Cheers,

Charax

http://support.microsoft.com/kb/929868

http://support.microsoft.com/kb/935400

http://www.neoblog.co.uk/?p=13