467,161 Members | 840 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Help speeding up forms


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?
Sep 21 '07 #1
  • viewed: 1207
5 Replies
How many users are using this application? (I had the same problem a while back)
Sep 21 '07 #2
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?
Sep 21 '07 #3
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.
Sep 21 '07 #4
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.

Sep 21 '07 #5
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.
Sep 21 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Snyke | last post: by
reply views Thread by Apollo | last post: by
12 posts views Thread by dvumani@hotmail.com | last post: by
3 posts views Thread by Jon Skeet | last post: by
2 posts views Thread by Robert Wilkens | last post: by
5 posts views Thread by jcrouse | last post: by
3 posts views Thread by Mark Reed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.