asked on

Custom Access application slow

Hello Experts,

15 months ago I wrote an Access application and the details screen is pretty detailed and during these 15 months I uppgraded and upgraded. The detail code is now 2261 lines and it takes around 8 second to load, which my client says that it is way to long. I know that if I rewrote this code it will probably half or less, but if there is less time consuming solution?

I have already run compact and repair and compile.

Any advice?

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

raysonlee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pancholefty

I don't know if this will work for your situation but it's worth looking at. I've used this software on my VB projects for many years with excellent results. It says it works with VBA but I haven't tried it with an Access app.

http://www.aivosto.com/index.html

No points -- just a thought

APD Toronto

ASKER

I will try your suggestions, but it takes 8 seconds to open one record and they open a lot of records everyday.

I think I will also look at the form load event, but is there any format to document on paper in plain English what that code is doing, so I have it for my record?

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Armen Stein - Microsoft Access MVP since 2006

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

APD Toronto

ASKER

Thank you all for your suggestions.

Appearantly, after upgrading from Access 2003 to 2007, the load time reduced from 8s to 4s. I doubt tht this is a permanent fix, but I will revisit this once it becomes a problem again :)