asked on

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.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

A similar situation just came up ... see if this applies to your case:

https://www.experts-exchange.com/questions/26854664/Why-does-it-take-my-MS-Access-linked-table-so-long-to-open.html?cid=1131&anchorAnswerId=35007468#a35007468

mx

slthom

ASKER

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.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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

slthom

ASKER

No conditional formatting. It is just slow as molasses on Win 7.

slthom

ASKER

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?

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Sorry ... I don't use SQL Server ...

mx

slthom

ASKER

I found the slow SQL problem

LLMNR protocol

Found this article:

http://social.msdn.microsoft.com/Forums/en/windowscompatibility/thread/f295994c-5812-4e46-8ac9-f05471d4dd54

and then did this change:

http://www.vistaheads.com/forums/microsoft-public-windows-vista-networking-sharing/122198-ability-disable-llmnr.html

Forms open just as fast as they did on Win XP.

ASKER CERTIFIED SOLUTION

ee_auto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial