Queries better to use SQL in Module or in Query Tab

[lora]

Is it better/more efficient to write queries with SQL in a code module or to write queries in the query tab? I have an application that has many queries 45 so far and will probably have at least an additional 50. I'm calling the queries from a code module. This could be a preference issue(?) but I wasn't sure if there were limits in access to the number of queries stored or if I would be using unncessary space so that it would be better to put in the module.

Thanks

Lora

 

[Terpsfan]

Queries run faster as saved queries within your database than they do as sql statements. Access optimizes the query when you save it and after the first time you run it. Access 2000 has bridged this gap a little. With DAO you can reference a saved query and execute it, which will run faster than explicitly typing out the sql statement.