speed up query

[Bob White]

I'm wondering if a canned query will execute faster if it is located in the
backend database on the file server instead of in the application database
on the user's workstation? By canned, I mean no parameters and stored under
the queries tab of the database. Specifically, I'm using an append query
that is appending to a table in the backend with data from other tables in
the backend database. If so, how does one go about invoking this external
query? In my experience so far playing with external data, Windows pulls
all data over the network then sends it back, even if it doesn't touch it.
Access 97.

Thanks,
Bob White

 

[Arvin Meyer]

No, an MDB won't run faster on the backend.

If your experience shows all the data coming over the wire, you need to
build better queries. In fact, a well-designed query, with proper indexes,
will only bring the indexed field(s) over the wire, then get only the
specific data. I have properly indexed queries that fill subforms from over
a half million records in under a second.

Good indexes are the key to optimum queries.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access