If I import a table from one database to another will does the updates transfer over to the imported table?
If I import a table from one database to another will does the updates transfer over to the imported table?
I'm not sure what you mean by the updates. The easiest way to look at the difference between linking and importing is that linking is the actual live data whereas importing is static data, so if you perform a change on the table in the external database then the information will not be updated on the table that you imported into the other database.
Dan H
Access Database Developer
try to understand the difference between importing and linking tables:
Linking Tables: it is basically like creating a short cut of a file. e.g you have a File sam1.doc in your documents. if you create a shortcut of the same on your desktop and open the file using the shortcut and enter data, the changes are saved in the File sam1.doc and the shortcut basically connects you to that file. so a linked table is basically a shortcut of the original table in another database. it changes made to it will update the original table located in the other database.
importing: its like coping the file sam1.doc from your documents to your desktop. now if you open sam1.doc on your desktop and make changes the changes are saved in the file that is on your desktop and in the File in your documents.
now updating data: it seems that you have two databases in two different locations one with recent updates and the other may not updated. you can do the following:
if your tables in this two databases are similar delete the tables in the database which is not updated and link the tables from the updated database into it.