Solved

Access 2003 forms slow on Win 7 Professional

Posted on 2011-03-02
9
654 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
 

Author Comment

by:slthom
ID: 35021618
No conditional formatting.  It is just slow as molasses on Win 7.  
0
Backup Your Microsoft Windows Server®

Backup 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: 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now