speed up query order

[sal21]

I ue Access the ordering all records base a column with the tipical A|a selectin it work very fast...
But if i use a sql query into vba code all are very slow!!!!!!!

note:
the column to reder entire records is just indexed

[HansV]

Access optimizes the execution of stored queries. But if you execute a SQL string in VBA, Access cannot optimize it.

Try saving the query. You can open a recordset based on a saved select query, or execute a saved action query (such as an update query or make-table query) in VBA.

[sal21]

Access optimizes the execution of stored queries. But if you execute a SQL string in VBA, Access cannot optimize it.

Try saving the query. You can open a recordset based on a saved select query, or execute a saved action query (such as an update query or make-table query) in VBA.

OK.... i know the way to open a recordset based on a saved select query, but not execute statement. can you post an example, based a query stored in Access named ORDER_RECORS

[HansV]

Is your query an action query, i.e. a make-table query, append query, update query or delete query?

[sal21]

Is your query an action query, i.e. a make-table query, append query, update query or delete query?

a simple order by sa:
select * from table order by test

[HansV]

That is a select query. You cannot execute select queries - you can open a recordset based on the query.