Solved

Access 2003 forms slow on Win 7 Professional

Posted on 2011-03-02
9
677 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
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 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