how to turn off the optimizer?

[MikeDutcher]

My query passes data to VBA through user-defined functions.

I need to control the order that the columns are executed.

I want them to execute from left to right.

Based on the quote below, I suspect the Jet optimizer is changing my column order execution and thus my VBA public variables are not set in the order that I intend.

How can I turn off the Jet optimizer?

"Jet's sophisticated query optimizer means that the end user and developer needn't be concerned about the order of columns and tables in the query definition. The Jet Query Optimizer decides upon the most efficient query strategy and reorders the query's tables and columns to best optimize the query."

 

[JeremyNYC]

I don't know that you'll be able to do that. You can build a query that uses another query as a source of data, though, which will allow you to choose the order in which functions are carried out. That's quite a common practice.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.