Solved

Access 2003 forms slow on Win 7 Professional

Posted on 2011-03-02
9
693 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

636 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