Access 2007 performance

finlaymcmillan

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

Apr 6 '07 #1

Hutch

Has there been any programing since the conversion?

I have had this issue in the past while viewing information on a query through a form. the issue i was having was a poor query set up, I maped out how information was being routed to the query and realized that while pulling information from a table it was also pulling information through another query, a query pulling from that same table. so in other words the query was preforming the same task twice.

Cleaned it up up, compact and repaired to ran like a charm. just poor design to begin with. Hope this helps some what.

Apr 6 '07 #2

finlaymcmillan

Has there been any programing since the conversion?

I have had this issue in the past while viewing information on a query through a form. the issue i was having was a poor query set up, I maped out how information was being routed to the query and realized that while pulling information from a table it was also pulling information through another query, a query pulling from that same table. so in other words the query was preforming the same task twice.

Cleaned it up up, compact and repaired to ran like a charm. just poor design to begin with. Hope this helps some what.

Thanks for the reply.

The application was converted then compiled. The only issue was changing the recordset dimensions to DAO.recordset from recordset as the application would not compile.

I will experiment with the main query to see if I can improve the speed.

Rgds,
Finlay

Apr 7 '07 #3