Loading forms in split DB takes a long time...

[Joe]

I have a the BE db in a network folder and the users have
the FE on their desktops. Opening forms on the FE takes 1
or 2 minutes to load. What can I do to make the forms
load more quickly?

 

[Albert D. Kallal]

The solution is to force the back end to be opened all the time. You can
accomplish this by some code that simply opens a table in the back end. You
can even open a little form, and then minimize it.

There is a few other things to also check, but normally doing the above will
fix your problem.

Check out the following for more info on performance, and what to check:

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

 

[Cheryl Fischer]

Access MVP Tony Toews has a number of performance tips at:

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

 

[Cheryl Fischer]

There are some valuable performance tips at Access MVP Tony Toews' website:

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