Hello Everyone,

We had same situation where we had application front end in Access 2003 and Backend SQL Server 2005, runs fast no probs.

Now we upgrade Access 2007 noticed perfomance issue, for example mostly works fine however it goes slow on one of recrod like list of dates and have to wait for long time wasn't previously.

Solution : i don't it's right solution or not but after long search i found that the ODBC Connection String ....

I had new ODBC connection string like in APP part it was 2007 Microsoft Office system

Now changed to Microsoft Office 2003 and works fine.....!

I would say look into your connection string and make changes to it and import table again and try it.

Good Luck.