Access 2007 slow calculations

[Dan8376]

In my office we have people with access 2003 and access 2007. We have a database that is split with the back end on SQL Server 2005 and the front end is an ADP Access 2002-2003 file format. For the users with access 2003 everything works great and has been for the last few years. For the access 2007 users, things are not working so great.

My only known issue so far relates to forms that are using functions as the control source to display data in a text box. The data will eventually display if you have 40 minutes, otherwise the form’s status bar just says Calculating. Note: This only happens when the forms are maximized.

In my own troubleshooting I've found some things that allow the calculations to work, but none of them are something that I want to use on a permanent basis.

1) If the form is not maximized, the information calculates as it should (1-2 seconds). Unfortunately the forms need to stay maximized.

2) If I set the focus to the text box that is using a function, with code or by clicking on it, then the information displays.

3) If I Compact and Repair the adp after I open it, then for the remaining time that I have the ADP open everything works like it should. Right now this is the best solution, but I would like to find the reason why this is happening, so I don't have to Compact and Repair the ADP each time I use it.

Thanks
Daniel

 

[boblarson]

Have you installed the Office 2007 SP1 yet? It seemed to speed several things up for me.

 

[Dan8376]

I've already installed SP1 for all of my office 2007 machines. Right now my most effiecent work around is having the user perform a compact and repair of the database. For some reason this allows everything to calculate in a timely manner.