Slow performance of a heavy VBA Access database in Access 2007

[chunchun]

We recently migrated a heavy VBA Access application in Access 2003 to Access 2007. This application resides on a network. This application has lots of forms, reports and modules. This application is performing awfully slow in access 2007.

When users are using the application, they have to wait atleast 5 to 10 seconds before they perform their next operation with the mouse. Sometimes it is worse, it hangs and they just have to wait for a long time.

The design view is much worse. It is frustrating sometimes. Infact I have 2GB memory on my machine and I am still having these terrible performance issues.

Please let me know if anybody else has this kind of issue. We already have the SP1 loaded. Is there anything, that can be done to improve the performance of the application within the database.

Please help............

 

[ajrimmer]

Yes, I've got the same issue, particualarly with one report which is using a number of vba functions.

I'm still pondering over a "better" solution (there must be one, just haven't worked it out yet).

 

[ToyFox]

Yes, I also migrated to 2007 recently and have the same issues. Note, SP2 is coming out at the end of April.
That might help with the network speed issue.
There is a hotfix on this issue. The December 16, 2008 hotfix. I believe the SP2 takes in the hotfixes...

 

[ToyFox]

I unchecked the NAME AUTOCORRECT configuration in the options and set my tables to SUB DATASHEET from [Auto] to {None]. Helped a bit on speed.

 

[ToyFox]

I applied the hotfix to one of our workstations this morning. It is the Dec. 16, 2008 ( I think it is KB960307).
The database that crawled ran like it did in Access 2003.
The users will be testing today, and if ok, then I will apply the hotfix to their workstations.
This should solve your performance issues.

 

[chunchun]

Toyfox,

Thank you very much for your reply. The Dec.16 2008 hotfix did help the performance of the Access 2007 app we had. The database started performing like it did in access 2003.

 

[ToyFox]

Hey,

Great, glad to help. I can't believe they released such a lousy product. Eventually they will lose this business.