View Single Post
  #8  
Old April 13th, 2010, 04:20 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.access.queries,microsoft.public.access.tablesdbdesign,microsoft.public.access
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Make Table v. Append to Table: Need Some Expert Design Inputs

To all,
The points about the realtionships and key fields remaining intact
is a point I did not consider.
That is a definite advantage/diference between Make and Append.
Excellent point! Thanks...
Al

"Al Campagna" wrote in message
...
MJ,
Make Table query vs. Append query is like a saw vs. a hammer.
They are two unique tools. So there's really no way to determine
"advantages/disadvantages" between the two. One is great for cutting
boards, and one is great at pounding nails... :-D

Make Table does create a "new" table, but only replaces an exisiting
table if the table name is the same.

Append is meant to add records to an "existing" table. While it might
be used to "act like a Make Table" (ex. two actions - delete all the
records
in an exisiting table, and then "append" records to that empty table),
there's really no need to do so when Make Table does the job in one
action.

Database size/growth is dependent on many factors.
Indexes, linked Images, record deletions, table deletions, editing,
etc.. etc... all contribute to DB growth.
Regular backing up and Compacting is essential to keep your DB slimmed
down.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"MJ" wrote in message
...
I am working on updates to a couple related databases (not linked by any
tables) and have a question about virtues of Make Table vs Append
queries.

Make Table: I understand that this will create a NEW table where ever it
is
pointed,
so if that table already exists in the destination it
will be deleted, and
the new table written in its place.

Append : In this case I understand that it would require a little
more
"work" to
do same as Make Table, i.e. clearing out table before
appending data.

The 1st major difference, other than additional steps, I can see is if
you
have a table structure you wish to retain the Append qry idea might be
more
favorable over the Make table qry.

Okay, now you database gurus...
(1) Are there any other advantages/difierences one over the other?; and
(2) What about database size impacts. grow/shrink, assuming the amount
of
data is fairly consistent from time to time of run?

--

MJ