difference between append en refresh with tabledef

[Abrm]

In this newsgroup I learned how to refresh my linked tables through code
But I also now that you can delete and append tables through code
Can someone tell what the difference is
What does it do with performance
Size of the application
etc.
Thanks.

 

[JohnFol]

They do different things.
Append adds a table
Delete deletes a table
Refresh updates the list of tables

 

[Abrm]

I know that....
But was does it do with the database.
What does it do with performance?
Size of the application?
etc.?

If I know the difference then I know which one to choose in my situation.

----- JohnFol wrote: -----

They do different things.
Append adds a table
Delete deletes a table
Refresh updates the list of tables

 

[John Spencer (MVP)]

My untested/uncomfirmed beliefs.

SIZE:
Refreshing links does just that and has minimal impact on the size of the database.

Appending (importing) tables adds the table and records to your database
(therefore increasing its size considerably).

Deleting tables removes them from your database, but no space is recovered UNTIL
you compact the database.

PERFORMANCE:
Linked tables seem to be slower than tables that exist in the database, but most
of the time my users don't percieve the difference in performance.

Appending and deleting tables takes time if you do it frequently. And if you do
it frequently, then you might want to examine the reasons for doing so.
Normally, it is not a good solution. If you do need to do it frequently, you
might want to consider creating a temporary database and linking to it for your
temporary tables. Access MVP Tony Toews has an example of this at his site.

http://www.granite.ab.ca/access/temptables.htm