Poor performance with Access 2007

[doggs]

I have a new computer with Access 2007 installed. I opened an .mdb
application created under Access 2003. The application runs but is
incredibly slow compared to how it ran on a slower computer under Access
2003. Queries that take 3 or 4 seconds under Access 2003 require 2 or 3
minutes to complete under Access 2007! The application reads linked tables
from an SQL database. It has macros. I disabled security to get it to run
under Access 2007 but have not changed the application itself in any way.
Does anyone have any suggestions or insights into this problem?

 

[Arvin Meyer [MVP]]

You may be able to get some performance tips at Tony Toews website:

http://www.granite.ab.ca/access/performancefaq.htm

 

[Tony Toews [MVP]]

You may be able to get some performance tips at Tony Toews website:
http://www.granite.ab.ca/access/performancefaq.htm

My website probably won't be that helpful as he is going against SQL
Server linked tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

I have a new computer with Access 2007 installed. I opened an .mdb
application created under Access 2003. The application runs but is
incredibly slow compared to how it ran on a slower computer under Access
2003. Queries that take 3 or 4 seconds under Access 2003 require 2 or 3
minutes to complete under Access 2007! The application reads linked tables
from an SQL database. It has macros. I disabled security to get it to run
under Access 2007 but have not changed the application itself in any way.
Does anyone have any suggestions or insights into this problem?

Can you delete and recreate all the table links? Just guessing but
there may be some bad cached table meta data in the table links.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Sylvain Lafontaine]

Any amelioration if you try to change the format of the file to ACCDB? or
create a brand new ACCDB file and import everything into it?

If you take a look with the SQL-Server Profiler, do you see anything
unusual?

 

[doggs]

I deleted and reestablished all links to the SQL tables. This did not
improve the poor performance I have seen. I then created the application in
the new Access format .accdb. Again, there was no improvement in the
performance.

I can now report that this poor performance is exhibited on two computers
running Access 2007 but not on three others still running Access 2003.

 

[Sylvain Lafontaine]

There have been many reports of high unusual activities that can be seen
with the SQL-Server Profiler when using an Access Data Project 2007 (ADP)
against SQL-Server (either 2000 or 2005).

Do you see anything unusual if you take a look with the SQL Profiler when
running your 2007 MDB or ACCDB files?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

 

[Tony Toews [MVP]]

I deleted and reestablished all links to the SQL tables. This did not
improve the poor performance I have seen. I then created the application in
the new Access format .accdb. Again, there was no improvement in the
performance.

I can now report that this poor performance is exhibited on two computers
running Access 2007 but not on three others still running Access 2003.

That was the only thing I could think of so I'll now bow out of this
thread.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm