471,091 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,091 software developers and data experts.

Optimizing Access 2002 Data Access Pages

I'm trying to link a Data Access Page in Access 2002 to a query.

This query returns many records and each record involves some
calculation.. therefore taking about 1-2 secs to calculate each row..

I was hoping that by using the grouping functionality I could hide the
details. The user could use the record navigation function to select
the day required and then by pressing the 'plus' button the details
would be calculated and displayed.

However, when opening the page it appears to be calculating all the
values for the entire recordset and therefore being very slow. Is
there anyway I can change this??

I'm hoping that there's a option on either the underlying query or the
Page itself, however I haven't been able to find it.

Many Thanks

Jan Griffiths
Nov 12 '05 #1
0 930

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Sean C. | last post: by
28 posts views Thread by deko | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
6 posts views Thread by Peter Frost | last post: by
52 posts views Thread by Neil | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.