• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Linking to Data

Importing tables into your Access databases creates an independent copy of the table you imported. Because the imported table exists independently of the original, any changes you make in one version of the table won't be reflected in the other.

If you want the changes made in either version of the table to be reflected in the other, you should link the table from the other program to your database instead of importing it. Linking a table to your database creates a logical pathway between the original table and the copy. When Access detects modifications in either version of the table, it changes both tables so they are identical.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint