• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Using External Data > Creating a Link to External Data

Creating a Link to External Data

If you need to keep the data in its original format but want to treat the data just like any other Access table, linking is the best solution. All the information required to establish and maintain the connection to the remote data source is stored within the linked table definition. You can create links through the user interface and by using code. This section covers both alternatives.

One of the most common types of links is a link to another Access table. You create this type of link so that you can place the application objects (queries, forms, reports, macros, and modules) in a local database, and so that you can store the tables in another database on a file server. Numerous benefits are associated with such a configuration. Chapter 20 discusses these benefits in more detail.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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