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
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
[quoted text clipped - 12 lines]
>> I've been experiencing the same poor performance with A2007 and
>> Vista. It's practically unusable.
Tony Toews [MVP] - 13 Jul 2007 01:53 GMT
>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

Signature
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/
Charax - 15 Jul 2007 12:02 GMT
Thanks Tony. Will do as you suggest.
Cheers,
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.
[quoted text clipped - 8 lines]
>
> Tony
DAVID - 13 Jul 2007 07:02 GMT
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
[quoted text clipped - 49 lines]
>>> I've been experiencing the same poor performance with A2007 and
>>> Vista. It's practically unusable.
Charax - 15 Jul 2007 12:04 GMT
David, where does one find the strict setting for TCP/IP (using Vista Home
Premium)?
Cheers,
Charax
> 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)
DAVID - 16 Jul 2007 01:40 GMT
http://support.microsoft.com/kb/929868
http://support.microsoft.com/kb/935400
http://www.neoblog.co.uk/?p=13
> David, where does one find the strict setting for TCP/IP (using Vista
> Home Premium)?
[quoted text clipped - 9 lines]
>>
>> (david)
Charax - 16 Jul 2007 09:58 GMT
Many thanks for the leads.
Cheers,
Charax
> http://support.microsoft.com/kb/929868
>
[quoted text clipped - 15 lines]
>>>
>>> (david)