jlathem
the choice of docmd.openquery compared with currentdb.execute depends on your needs to some extent. they are slightly different
if you suppress warnings the docmd.openquery can (may) partially or even completely fail without notfying you at all. in some cases the warings/confirmations may actually be desirable
wheres with currentdb.execute, you never get any warnings as such, at all - although you can suppress the whole query execution in the event of any failures.
it really depends whether you expect any failures, and ho you want to react if there are any.