Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Access 2007 with Vista performance slow

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Charax - 18 Jun 2007 01:18 GMT
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@gmail.com - 18 Jun 2007 18:10 GMT
yeah; don't use linked tables-- use Access Data Projects

> I have Access 2003 on a Win XP Pro SP2 desktop (512 MB RAM) and SQL Server
> 2000 database (50,000 records).
[quoted text clipped - 18 lines]
>
> Charax
Charax - 23 Jun 2007 01:10 GMT
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?

>I have Access 2003 on a Win XP Pro SP2 desktop (512 MB RAM) and SQL Server
>2000 database (50,000 records).
[quoted text clipped - 19 lines]
>
> Charax
wpowell@bohangroup.com - 03 Jul 2007 21:08 GMT
I've been experiencing the same poor performance with A2007 and
Vista.  It's practically unusable.
Charax - 07 Jul 2007 09:22 GMT
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

> I've been experiencing the same poor performance with A2007 and
> Vista.  It's practically unusable.
Charax - 12 Jul 2007 08:31 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.

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)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.