Solved

Access 2003 forms slow on Win 7 Professional

Posted on 2011-03-02
9
691 Views
Last Modified: 2012-05-11
I have an Access FE and SQL Server 2005 Express BE database that runs great on Win XP Pro.  I recently bought a computer with Win 7 Professional 32-bit, and the Access forms open painfully slow.  On XP Pro, it takes less than a second for one of the forms to open, but with Win 7, it takes 15 to 20 seconds for it to open.  Anyone else experience this and do you have a solution that worked?

Thanks for any insight.
0
Comment
Question by:slthom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 75
ID: 35019555
A similar situation just came up ... see if this applies to your case:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26854664.html?cid=1131#a35007468

mx
0
 

Author Comment

by:slthom
ID: 35019960
I don't believe so.  If I open the database window and open the tables directly, they are super speedy fast opening.  It occurs when I open forms and "Calculating . . ." is displayed in the bottom left corner of the screen.
0
 
LVL 75
ID: 35019999
ok.  Are you using Conditional Formatting anywhere ?
I really have not experienced any such issues with Win 7 x64 Office 2010 ... with limited use however.

mx
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:slthom
ID: 35021618
No conditional formatting.  It is just slow as molasses on Win 7.  
0
 

Author Comment

by:slthom
ID: 35087365
OK, I just installed SQL server on my local machine and linked those tables.  It is back to normal speed.  Must be a network issue with my Win 7 machine connecting to the SQL server over the LAN.

Any ideas?
0
 
LVL 75
ID: 35087390
Sorry ... I don't use SQL Server ...

mx
0
 

Author Comment

by:slthom
ID: 35112022
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 35356866
Question PAQ'd and stored in the solution database.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question