Help speeding up forms

[RobinAG]

Hello,

I just split my database into front and back end. My front end users are experiencing really slow opening of forms. I've searched online for help speeding up forms, but I'm not sure what the best way is with my current setup. I've inherited the database from a previous programmer, and he set things up a little uniquely.

Here's the deal:

I have a main form that opens, listing in a subform all of the projects, with some top-level data. Double clicking on the record selector opens up the individual project form (frmProject). That's where it goes slow.

frmProject is an unbound form, and in the "on open" event, the VBA code calls a long list of methods that collects the data based off of the ProjectID, and dumps that data into the appropriate fields in frmProject.

I tried converting the front end to MDE, and it did speed things up a bit, but still too slow.

Since I split the database and linked the front end to the back end tables, things have gotten really slow. The back end is placed on: L:\Translation Unit\Backend.mdb, and the frontend is palced on: L:\Translation Unit\Front\Frontend.mdb.


Any ideas?

[RobH]

How many users are using this application? (I had the same problem a while back)

[Ian Brown]

From what I have read, the front end is to be on the local drive ie the c:\ drive. Could it be that with the front and back been on the same drive it would slow it down?

[barry07]

You havent said what operating system you are using so this is something of a guess.
I imagine that durng the Form Load event the links between the front end and back end are set or refreshed.

I found with early versions of XP (i.e before SP2) that this process could be very slow. Worse, the links were refreshed every time the form was opened.

SP2 seemed to fix that.

Hope this helps.

[RobinAG]

I am using SP2. There are between 6-10 users at a time. I tried putting the front end on the stored locally, but that actually made it even slower, I had assumed because the data had to be pulled from so far away.

Barry, how can I avoid having the links refresh every time I open? I assume that that would make the form open slow the first time (when the link is established) and every time afterwards would open quickly.

Robin

[RobinAG]

I converted the front end to an MDE file, placed on the C-drive, and performance has been better. However, still opening the forms is slow.