Discussion Locked

Access97: Startup Speed

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have a VB app that starts an access database. The time it takes for Access to start and display a form can vary from 2 seconds to 15 seconds. Does anyone know what determines the startup time and how it can be minimized?

7 replies

by anthony m

Hi there,
Well without more information about how your VB app opens the Database this is a complete stab in the dark: -
If your form is bound to a table or query and is filtered on certain criteria the amount of data returned to the form could impact the load speed. You can change the perception of load speed by pre loading the form and hiding it until it is ready to display the information, then instead of closing the form you can just hide it ready for the next use.

by sl-campbell

How long does it take for Access to load the database when you double click on MDB file name in Explorer?

What is the purpose of the form in Access?
How large is the table that is behind the form being opened, (number of records and fields, andif any OLE fields are in the table). If the table isn't that big and there aren't any OLE fields or pictures being stored in the table, then it should show pretty fast.

And, how is Access being started from VB - using an OLE container, or by Creating the object, or Shell? how long does it take to see the Access splash screen after initiating the start from VB.

The reason I ask is trying to find out where the possible problem is: With-in Access or the way Access is called from the VB application. And if the correction needed in only the perceived time or an actual structural or code change correction.

by pcarter

The form is a password-entry form that is not bound to any table or query. The VB app starts the Access database using Shell, but the variable time to display also occurs when starting the database by double-clicking. The Access splash screen displays quickly.

by andersos

Do you have an Autoexec macro setup? The code running in this macro will slow down your initial form load. Have you tried compacting your database and then compiling and saving it. This can often speed up the whole database. The slow load time could also be due to your network performance.

by sl-campbell

You shouldn't reject an answer when more input is being requested, and esp. if the original question is clearly missing factors that are needed in order to determine where the problem is and how to help you, and when a solution is not given by another.
This could be considered rude and may keep others from giving any answers at all, now or in the future.

The problem sounds like a lack of local ressources, (too less disk space, ram, etc.), or a slow network or network with alot of traffic attimes. This would explain the differences in time - if there is alot of network traffic, or if you have some resource eating programs running locally at the same time, esp. with low resources to begin with.

by pcarter

There is an AutoExec macro, but even when opening the form is the first action in the macro, there is still a variable time to open the form. Computers have plenty of RAM (64 MB) and high-speed processors (400 MHz). There is normally a VB app running at the same time, but the variable time to open the form occurs without it.

This discussion is closed to new replies.