Access slow!

[pgp]

Hi all,

I have a a quote system DB in access developed which is about 10.5 MB in size.

I have a main switchboard with 6 different buttons - taking to different forms.

EVerytime I click on a button on the switchboard it takes a very long time before it opens the form.

Is this because of the size? or ?

I dont have so many other apps running too!

Any input would be appreciated

 

[The_Doc_Man]

Factors that can slow down opening a form...

1. DB needs to be compressed. (Fix by compressing.)

2. Code standing between the button and the form inside your switchboard. (Examine the code underlying the button, see if something heavy-duty is going on behind the scenes before activating the form.)

3. Code in the forms (class module) needs to be compiled. (Open a code window. Compile and Save All Modules. Then consider #1 again.)

4. Forms contain network links to graphics. (Make copies of the graphics to the folder containing the DB. Then change the links.)

5. Extensive startup code in the Form_Load or Form_Current event. See advice for #2, but this time check the individual forms.

6. Network slower than a garbage scow. (Sorry, can't help much there.) Or DISK slower than a garbage scow.

7. Forms are bound to a complex query involving ugly JOINs that lead to a very large temporary data set. (Examine the recordsource for each form.)

8. System is tuned poorly. It gives too little time to the foreground task and too much time to background tasks. (Requires adjustment from the Start >> Control Panel - I think.)

 

[pgp]

Still slow

Hi,

I did try almost all of your steps, but still access seems to be slow.

I have windows 2000 on my PC.

When I open the db - it opens the switchboard faster, but when I click on the buttons on the switchboard , it takes around 30-45 secs to open. But once the main form is opened, all the other forms that are opened through this main form are faster.

Its only the forms through the main switcboard.

I tried the performance analyser, and optimized the db.

Is there any other things to keep in mind or check for?
Thanks in advance

 

[st3ve]

Same but different

Sadly, no solution but consider this...

I've recently had a similar 'long opening delay' on a small db i was developing to go on an Access 2002 machine. I use Acc2k in the office. After i did some work on the db at the clients pc i took a copy to load back to my PC. I don't know for sure that this was the source of my problem but ...

What i'm seeing is that, if i say, modify any design aspect on a form, when i go to form view to see the changes, it takes 30+ seconds to open. The form open at usual pace if opened from scratch though!

 

[pgp]

Access 2002 might help?

Hi !

Thanks for your response. So from what you suggest, will the speed show a considerable change if I go with access 2002 instead of 2000? I am currently working on access 2000.

Im facing the same problem that you had mentioned.
Its wierd that the form takes so long to open.
EVne when i make changes to code and save, it takes quite long.

Will changing the location of the db help?
right now its in a shared network drive. Im planning to change its location and see

Just for info, im using windows 2000.