Access 2007 slow

[JamesDSM50328]

I've been trying to figure this out for a while, recently we were forced to convert our Access 2003 databases to Access 2007 (company required it) after conversion the performace decreased dramatically, what used to take a couple seconds now takes a couple minutes.
The database is not split and spliting did not increase the performance.
Rebuilt the tables and indexs and that did not help.

The weird thing is when I access the database via a VB6 application the performance is fine.
I don't want to rebuild all the functionality that is in the database into a VB6 FE.
Can anyone give any suggestions as to why this is happening and how to possibly correct?

 

[MrDataGuy]

I do not have a perfect answer for you, but this is what I would do if I was you and no one has a better answer.

First based on your posting it ‘smells’ to me that the issue is not with the data proper but with the coding in the screens etc. that is most likely the issue. Pick some part of the app that is slow and log the time (or output to a messagebox etc) of several sections of the code. Find the slow spots. Maybe do the same thing to the older 2003 version. Slowly you will find lines, or maybe one line that is causing the issue. Would not be surprised to find that it a SQL statement ( or view or query etc. ) that is running slow because the SQL Syntax needs to have a small adjustment. (The SQL statement issue is a real shot in the dark idea. )

I suspect that you will wind up posting a new question like: Why does statement X run fine in 2003 and not in 2007 and what can I replace it with, at the end of this process.
Hope this help, and wish I had a better targeted answer, but it is what it is.


Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com

 

[bubba100]

James have you looked at

http://allenbrowne.com/Access2007.html

Plus are you running the most current version of 2007, are you current on all the updates?