I tried converted an application that started life in Access 97 and is currently in Access 2003.
The performance in Access 2007 of the main tabbed form has degraded considerably moving from record to record.
It appears to be the data refresh on the form that is the issue and not retrieving the data.
The refresh of the data has a scrolling effect. In addition, the record selector will only move one record at a time if you click and hold.
In Access 2003 it would move 50 records if you click and hold in the same time it takes to move 1 record in 2007.
This is a large scale system specifically coded for performance.
Can anyone comment?
Thanks,
Finlay McMillan