[AccessD] Performance issue - QueryDef

Stephen Bond stephen at bondsoftware.co.nz
Mon Nov 24 20:54:20 CST 2003


Line 3 below takes 4 seconds to execute:
 
    1.  Dim db as DAO.database, qdf as DAO.QueryDef 
    2.  set db = Currentdb() 
    3.  set qdf = db.QueryDefs("qryTransactionEntryFormGenerate")
        4.  For each prm in qdf.Parameters
        5.    prm.value = Eval(prm.Name)
        6.  Next prm
        7.  qdf.execute
 
The query is an Append query, the table being appended to is empty.  The execution time is negligible.  Why should line 4 take so long??

Stephen Bond 


Man will occasionally stumble over the truth,
but most of the time he will pick himself up
and continue on.
-- Sir Winston Churchill




More information about the AccessD mailing list