Ok folks I am at a lost on this or maybe not you decide.
I have split my database as suggested to me by you all. No problems doing so and life seems simple.
On our local network (running at 1.5mbps) the front ends on 2 computers run great no performance issues at all.
However, we have a remote base which is running dsl at .5 mbps. When I run the front end there it takes FOREVER (+ 1 day) to load my main form. When I say forever it takes at least 1 1/2 minutes (yes minutes). This form gets data from 2 tables residing back on the good old home server. One piece of information is to populate a combo box with pilot names in there and the other table used is where the information for the form will be stored. That's it.
So I guess my question is can someone explain to me how Access transfers data between the FE and the BE ?
What would cause it to be this slow? The BE is about 2 mb and the FE is also about 2 mbs. I was under the impressive only small bits are flying back and forth. So the second question would be if that is the case do I need to improve my code? I really don't know how as all I am doing is opening a BLANK form and loading 30 names into a CBO...
Seems odd to me to be this slow.
Any insight would be great. MS help isn't any...
I have split my database as suggested to me by you all. No problems doing so and life seems simple.
On our local network (running at 1.5mbps) the front ends on 2 computers run great no performance issues at all.
However, we have a remote base which is running dsl at .5 mbps. When I run the front end there it takes FOREVER (+ 1 day) to load my main form. When I say forever it takes at least 1 1/2 minutes (yes minutes). This form gets data from 2 tables residing back on the good old home server. One piece of information is to populate a combo box with pilot names in there and the other table used is where the information for the form will be stored. That's it.
So I guess my question is can someone explain to me how Access transfers data between the FE and the BE ?
What would cause it to be this slow? The BE is about 2 mb and the FE is also about 2 mbs. I was under the impressive only small bits are flying back and forth. So the second question would be if that is the case do I need to improve my code? I really don't know how as all I am doing is opening a BLANK form and loading 30 names into a CBO...
Seems odd to me to be this slow.
Any insight would be great. MS help isn't any...
