why does my forms take so long to load

[Jan T.]

I have made a db in Access 2000 and 2003 and uses Access 2007 runtime for my
users to use the database. There are about 5 - 7 users but normally only 2
or 3 at the same time.

However, when a user tries to load any form, it can take from15 to 60
seconds?
Is there anything I can do to make it load faster?

The database is split into a front end on station C (PC's HD) and a backend
i located on a network folder.
The forms contains som vba functions to look up different values. I also do
have some vba code for opening
forms etc.

Thanks for any help!
Regards
Jan

 

[Albert D. Kallal]

I have made a db in Access 2000 and 2003 and uses Access 2007 runtime for
my
users to use the database. There are about 5 - 7 users but normally only
2 or 3 at the same time.

However, when a user tries to load any form, it can take from15 to 60
seconds?
Is there anything I can do to make it load faster?

Try working you way through the following list.....

http://www.granite.ab.ca/access/performancefaq.htm

 

[Arvin Meyer [MVP]]

Form loading should never be based upon the number of users. Have you split
your database and put the front-end on each workstation? If not, you need to
do so.

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm

 

[Tom Wickerath]

Hi Jan,

This document might provide some useful information to you:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

In particular, make sure you have Name Autocorrect and SubDatasheets
disabled, and that a persistent connection is established. Do a compact and
repair on both the front-end and the back-end databases. Also, check out the
sections subtitled "Use indexes" and "Use JETSHOWPLAN".


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Jan T.]

Thank you a lot. I had a look and there are several things I would like to
try like
making the path to the Back End Shorter like S:/AccDb/myDB.mdb and change
the database name to a much shorter one and so on.

Thank you very much for your suggestions.

Regards
Jan

 

[Jan T.]

I have installed the Front End on every single PC's Hard Drive (C and the
Back End on a shared folder on the network. That way it is easy to do
changes
in the Front End versions and distribute new versions by email. Vba code
then installes the new version to each PC's station C.

Thanx anyway for your suggestion.

Jan

 

[Jan T.]

Thanx a lot. It seems to be a lot of information that can be very helpful
here
so this is super information for me. I will certainly take a closer look at
it.

Regards
Jan

 

[Tom Wickerath]

Hi Jan,

...and distribute new versions by email.

Even easier yet (a lot easier) is to use Access MVP Tony Toews' free Auto FE
Updater utility.

http://www.granite.ab.ca/access/autofe.htm
http://www.granite.ab.ca/access/autofe/gettingstarted.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Jan T.]

That sounds like some interesting tool that I could use.

Until now, I have had an Excel file with some vba code. It had a button
on a worksheet. First I saved a new FE version on the network.

Then, by clicking the update button, the new Front End was replaced
automatically.
Excel copied the new FE and saved it on each mail receivers PC's station C.
The Excel file was attached to my email and it works just fine.

I quess this one you mention is more developed and professional so that
will be interesting to have a closer look at. Looking forward to try it.

Thanx again!

Regards
Jan

 

[Tom Wickerath]

Hi Jan,

With the AutoFE Updater utility, you distribute a shortcut one time to each
user's PC. You can place copies of the shortcut on the desktop, in Start |
Programs, etc. The shortcut has a specially created target that points to an
executable file. All the user need do is use the shortcut to start the
application. If you, as the developer, have placed an updated copy of your FE
into a shared folder, and you have configured the .ini file correctly, then
the user will automatically get this new copy whenever they use the shortcut
to start your application. (It won't work if they attempt to simply
double-click on your .mdb file, or to open Access first and then open your
..mdb file; they have to use the specially created shortcut in order for the
AutoFE Updater functionality to work correctly).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________