Need to improve / shorten startup of DB

  • Thread starter Thread starter PosseJohn
  • Start date Start date
P

PosseJohn

Some of my users are complaining that the amount of time it takes to load the
DB application and associated data.

How do I improve load time of the DB?
 
Everything else notwithstanding, keep in mind that 'slow' is all subjective
and that there are usually person's within an organization that consider 5
seconds 'slow'. While looking for potential bottlenecks in the startup
certainly isn't a bad idea, temper the comments against the reputation of the
people making them as well as the feedback from the other users. Also, if
your environment is a mix-mash of PC's it might be that its something related
to the person's PC.

Also, do you have some sort of progress meter or form that displays the
startup status? Adding one that gives the user information on the startup has
a magical way of improving the startup speed even when you haven't changed
any of the code. Its a psychological thing.
 
On Sun, 16 Aug 2009 14:04:41 GMT, "JimBurke via AccessMonster.com"

That is NOT a recommended procedure. This option is undocumented for a
reason.

-Tom.
Microsoft Access MVP
 
Is your database split?

If so, does each user have their own front end on their PC?

If not, you need to split it, put the data on a shared network drive, and
give each of your users their own copy of the front end (installed on their
PC).
 
Back
Top