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 pcarter
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
by andersos
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
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending