E
Edwin van Ree
Hi,
I have been reading the other treads about slow performance in a Access 2007
application; I have a similar thou different problem.
My application worked fine and fast in Access 2003 and Windows XP. In the
resent months we upgraded our notebooks and workstations to Vista, SQL server
to 2005 and Office to 2007. It is very hard to exactly determine when the
troubles started and what is causing it. The problem only occurs in some
forms which use a larger table (35,000 rows, not realy large).
The problem is as follows:
When I open the form with Inventory items it opens quickly, even with the
population of a combo box with all 35,000 item names in it. The form has
multiple tabs with different fields related to this Inventory table. Clicking
through these fields goes very quickly, just normal response.
When I navigate to an Inventory item somewhere down the list, suddenly
clicking the different tabs get very slow (seconds delay). Even just editing
a field and moving the text cursor around is extremely slow. This happens
when the database is on my notebook or on my Windows 2003 server. I noticed
that during this phenomena the CPU on the notebook or workstation goes up to
50% (dual core), so 100% for 1 CPU. I did SQL tracing: nothing special going
on during the slow period.
It does not seem to be Basic code we wrote is running, it seems Access is
internally looping for a while.
The problem goes away when we close this particular window and do something
else. It comes back when we repeat the procedure above.
Access is only using around 100Mb in its working set and the notebook has
plenty memory left.
Any ideas?
Thanks, Edwin
I have been reading the other treads about slow performance in a Access 2007
application; I have a similar thou different problem.
My application worked fine and fast in Access 2003 and Windows XP. In the
resent months we upgraded our notebooks and workstations to Vista, SQL server
to 2005 and Office to 2007. It is very hard to exactly determine when the
troubles started and what is causing it. The problem only occurs in some
forms which use a larger table (35,000 rows, not realy large).
The problem is as follows:
When I open the form with Inventory items it opens quickly, even with the
population of a combo box with all 35,000 item names in it. The form has
multiple tabs with different fields related to this Inventory table. Clicking
through these fields goes very quickly, just normal response.
When I navigate to an Inventory item somewhere down the list, suddenly
clicking the different tabs get very slow (seconds delay). Even just editing
a field and moving the text cursor around is extremely slow. This happens
when the database is on my notebook or on my Windows 2003 server. I noticed
that during this phenomena the CPU on the notebook or workstation goes up to
50% (dual core), so 100% for 1 CPU. I did SQL tracing: nothing special going
on during the slow period.
It does not seem to be Basic code we wrote is running, it seems Access is
internally looping for a while.
The problem goes away when we close this particular window and do something
else. It comes back when we repeat the procedure above.
Access is only using around 100Mb in its working set and the notebook has
plenty memory left.
Any ideas?
Thanks, Edwin