I am using the below code to create a new query
Set qdfNew = Dbs.CreateQueryDef(strQryName,strSQL)
Now while the below code works it is slow when the new query is created in the currentDB.
If I set the Dbs to repicated database the query is created very fast.
I tried the above code setting the Dbs to a totally new database file and that to was slow.
WHY DOES THE RUNNING SPEED OF THIS CODE CHANGE BETWEEN DATABSES WHEN THE strSQL IS EXACTLY THE SAME ???
It is always faster when the query is created in a replicated database or even in the design master.