Hello,
I am attempting to convert some Access XP MDB files to Access 2007. I am experience some horrendous performance problems. We are a bit unusual in that we use Access as a RAD tool and almost all of our data resides in Oracle tables linked to by our Access front ends.
The issue I am experiencing concerns opening tables in the UI. If I open a table by double clicking it, a datasheet view is displayed (rather quickly) as usual, filling the page with information. The UI is responsive while Access populates its recordset in the background. (e.g. the the record count on the record navagtion bar is not displayed). As soon as I click in a column defined as a date, the UI hangs, network trafic and CPU usage rise dramatically and the Access Window displays "not responding". It appears that Access is attempting to retrieve all the rows in the table. After 3 minutes or so, the UI becomes responsive, CPU and Network traffic return to normal and the record count is now displayed (roughly 900K records).
This is "bad" (and also not what Office XP did). Please can anyone help?
Thanks
Vince Tabor
I am attempting to convert some Access XP MDB files to Access 2007. I am experience some horrendous performance problems. We are a bit unusual in that we use Access as a RAD tool and almost all of our data resides in Oracle tables linked to by our Access front ends.
The issue I am experiencing concerns opening tables in the UI. If I open a table by double clicking it, a datasheet view is displayed (rather quickly) as usual, filling the page with information. The UI is responsive while Access populates its recordset in the background. (e.g. the the record count on the record navagtion bar is not displayed). As soon as I click in a column defined as a date, the UI hangs, network trafic and CPU usage rise dramatically and the Access Window displays "not responding". It appears that Access is attempting to retrieve all the rows in the table. After 3 minutes or so, the UI becomes responsive, CPU and Network traffic return to normal and the record count is now displayed (roughly 900K records).
This is "bad" (and also not what Office XP did). Please can anyone help?
Thanks
Vince Tabor
