Faster SQL / Access queries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have an Access 2002 frontend / SQL 2000 backend program. The
program uses pass-thru queries to populate 5 listboxes in one of my forms.
(average 6 columns of 20 - 50 records).

I use the query name with the rowsource property
(ie: .lst_Revenue.RowSource = "sp_Performance_Master")

I would like to see if there is a faster more efficient way to populate this
data, though its considered fast (15 - 20 seconds to fill form), I'd like it
faster if possible.
Is there a better way thru code to populate these listboxes to increase
download time? I realize their maybe other factors: network, server
performance, form design etc.

thank you.
 
do you have correct indexes created in each table in SQL Server?

Ed
MCP - Access and SQL Server
 
If the data is in a list box, can I presume it's read only and doesn't
change too much?

If so you could consider a download to a local Access table when the
application first starts . ..
 
Back
Top