On my main form I am using text boxes with their control source pointing to their respective queries IE: (=DCount("*","QueHVBServiceOrders"). On my PC this data populates instantly. However as soon as I dump it on the server it takes several minutes to populate. If I open a query on the server the query fires up right away. No other speed problems noted, Just when using this DCount code. Does anyone know how I can achieve this data on the main form instead of the way I am doing it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query population slow on main form.
- Thread starter Xenos132
- Start date
Oh dear - domain aggregates on linked tables ...
That's one of the things you need to avoid to keep up the speed ... try fetching the info through opening a recordset in stead.
Here are some more hints on speed issues
Roy-Vidar
That's one of the things you need to avoid to keep up the speed ... try fetching the info through opening a recordset in stead.
Here are some more hints on speed issues
Roy-Vidar
- Status
Similar threads
