Access 2003 forms slow on Win 7 Professional

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.
slthomAsked:
Who is Participating?
 
ee_autoConnect With a Mentor Commented:
Question PAQ'd and stored in the solution database.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
slthomAuthor Commented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
slthomAuthor Commented:
No conditional formatting.  It is just slow as molasses on Win 7.  
0
 
slthomAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Sorry ... I don't use SQL Server ...

mx
0
 
slthomAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.