[AccessD] Which is faster DAO or Append Query? (in this case)

Rocky Smolin rockysmolin at bchacc.com
Thu Dec 19 10:16:28 CST 2013


Dear List:
 
I have a form which is bound to a temp table.  When the form is opened, the
temp table records are deleted and re-created with an append query - two
tables and two queries linked up.  It appends 36 fields.
 
The user reports 5-10 seconds delay opening the form and it is due, AFAICS,
to the append query.
 
I have always done a lot of stuff in DAO and find it to be easy to write and
fast in its operation.  So I could do this in DAO but would it be any
faster?
 
MTIA
 
Rocky
 


More information about the AccessD mailing list