|
|
||||||
|
#1
01-26-04, 08:11 AM
|
|
|
|
|
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. |
|
|
|
#2
01-26-04, 02:24 PM
|
|
|
|
|
They do different things.
Append adds a table Delete deletes a table Refresh updates the list of tables "Abrm" <anonymous> wrote in message news:1bd2 [..] |
|
#3
01-27-04, 10:31 AM
|
|
|
|
|
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 "Abrm" <anonymous> wrote in message news:1bd2 [..] |
|
#4
01-27-04, 01:44 PM
|
|
|
|
|
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 Abrm wrote: [..] |
|
|
| Similar Threads | |
| linked view from database, Can append but not refresh- help? I have a database which is linked to another and provides a view. The view is then imported to a table by an append query. I need to be able to refresh the data in the... |
|
| Refresh Form Prior to Append Query I think this is a simple question but..... I have a form with an 'accept' button I've built at the bottom. When the user hits accept is runs an append query using some of... |
|
| Refresh a subform after an Append Query Access XP running on WinXP sp2 Using a tabControl, on one of the tabs have two subforms. in the first subform, I select three items from comboboxes and enter a numerical... |
|
| Timing Difference: insert vs. append & reverse Dear all, I tried the test program below. My interest is to examine timing differences between insert vs. append & reverse for a list. My results on my XP Python 2.3.4 are as... |
|
| Append/Refresh Tables Hi, I am trying to append records to table using an append query. However, I only want to add new records and avoid duplicates. I will probably run this daily. I... |
|
|
All times are GMT. The time now is 06:26 AM. | Privacy Policy
|
difference between append en refresh with tabledef