A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access runs slow under Windows 7



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 08:31 PM posted to microsoft.public.access.forms
Mark A. Sam[_3_]
external usenet poster
 
Posts: 468
Default Access runs slow under Windows 7

My client has new machines with Windows 7. On an Access 2002 app, a
particular screen takes 90 minutes to load running under Access 2007. On
another new laptop running XP, the same screen takes about 10 seconds
running Access 2007. On a remote desktop session running Access 2002 it took
2 seconds.

Is anyone else having this problem and did you cure it?

Thanks for any help and God Bless,

Mark A. Sam


  #2  
Old May 18th, 2010, 03:34 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Access runs slow under Windows 7

Hi Mark,

I've been running Access 2003, 2007, and 2010 under Windows XP and Windows
7. My XP machines are considerably faster because I have more RAM on most of
them, but even on a 1 GB netbook, forms are still spunky runningAccess 2010.
The difference might be a few seconds (1 sec with 3 GB and 3 sec with 1 GB
and a slower processor)

The worst form I have takes at most 20 seconds to load, but it must deal
with 12 million records.

Try, rebuilding the database by importing all the records into a new clean
database created on the target machine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Mark A. Sam" wrote in message
...
My client has new machines with Windows 7. On an Access 2002 app, a
particular screen takes 90 minutes to load running under Access 2007. On
another new laptop running XP, the same screen takes about 10 seconds
running Access 2007. On a remote desktop session running Access 2002 it
took 2 seconds.

Is anyone else having this problem and did you cure it?

Thanks for any help and God Bless,

Mark A. Sam



  #3  
Old May 18th, 2010, 11:40 AM posted to microsoft.public.access.forms
Mark A. Sam[_3_]
external usenet poster
 
Posts: 468
Default Access runs slow under Windows 7

I got this resolved by compacting the backend databases.


  #4  
Old May 18th, 2010, 11:42 AM posted to microsoft.public.access.forms
Mark A. Sam[_3_]
external usenet poster
 
Posts: 468
Default Access runs slow under Windows 7


"Arvin Meyer [MVP]" wrote in message
...
Hi Mark,


Try, rebuilding the database by importing all the records into a new clean
database created on the target machine.


Thanks for the response Arvin. The frontend is an .mde file which is
updated everytime the user logs in to Windows. It is copied to the local
drive. Since it was working ok on XP I didn't consider that was the issue,
but probably worth making a new .mde. I got resolved, however by compacting
the backend databases.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.