Slow searches after update to 2010 data

[Gkirkup]

I have a big application, which we updated to Access 2010 a month ago. It ran fine. Then we also just updated the data from 2003 to 2010. Now we have very slow searches of big tables/queries, and the tech says that 'cpu usage on the server has gone to 100%'.
What can be happening? Nothing else has been changed except that the data has been updated to 2010 accdb.

Robert

 

[Estuardo]

G'd afternoon,
I have to ask this: did you compact & repair your db? Did you notice the difference in size?
Copy your db locally and verify that in fact the problem is your db and not the server/Lan

 

[jdraw]

Do you have indexes on your tables?

 

[Simon_MT]

This applied to Access 2007, it was suggested to set the table property SubDatasheet Name to None

Simon