I have an MS Access 2010 accde application in 60 + counties. This project has been ongoing for about 10 years. Each user has the FE accde on their desktop. I update the users from the web. The back end data is in Sql Server 2008 Express and the FE connects via a DSN-less ODBC connection I create in my code.

My problem is with Windows 7 64 bit. A search across 100,000 + records that takes 2 seconds in Windows 7 32 bit can take up to 4 or 5 minutes on Windows 7 64 bit.

I can put the FE on Windows XP and it runs quickly. It seems as if Windows 7 64 bit is stomping on the ODBC connection somehow.

I have used both the 32 and the 64 bit ODBC administrator tool to create ODBCs without any improvement. I dropped the DSN-less connection code and linked the tables via the 32 and 64 bit ODBC files with the Linked Table Manager. No improvement. The files compile. I have decompiled without improvement. The behavior is universally slow, not localized to a couple of forms or tables.

My MS Access 2010 is Version 14.0.5128.5000 (32 bit).

Any suggestions, guidance, pleas to a higher deity, anything would be greatly appreciated. I have additional clients I planned on moving to MS Access 2010 and converting the back end data to Sql Server but this slowness has me completely baffled.

Thanks in advance.

It's not the first time I read something similar to what you describe. Unfortunately I never saw any working solution proposed;

Have a look at:
MS-Access 2010 slow queries performance - Microsoft Answers
Access 2010 running super slow from server
Access 2010 running extremely slow
Microsoft Access 2010 running too slow - Access World Forums
and see if you can find some useful pieces of information from there.