Simple questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am downloading data from ODBC tables ( The servers aren't local and processing time is killing performance).
Anyway, I am currently using make-table queries for my application.

?Is there an advantage (processing time) to using append queries versus make table queries. Also, would an append query capture any updates to existing records (For example, an employee going out on maternity leave would become "Inactive" even though a new record isn't necessary).

Thanks
 
Is there an advantage (processing time) to using append queries versus make table queries.
Click to expand...

Yes; a MakeTable query must jump through a lot of hoops creating the
fields, registering the table in the MSysObjects other systems tables,
updating the database window, etc. Appending into an existing table
avoids all this. In addition, if you pre-build the table you can
specify exactly the field types, field sizes, formats and indexes that
you want.
Also, would an append query capture any updates to existing records
(For example, an employee going out on maternity leave would become
"Inactive" even though a new record isn't necessary).
Click to expand...

No, but an Update query can do so. You'll probably need both an append
and an update. Alternatively, if you just want to discard all the
existing data and replace it (as you would with a MakeTable) simply
run a Delete * From tablename query and run an Append.
 
John

I appreciate your insight into the two procedures. Hopefully, I'll be able to take from here.
 
Back
Top