Share via

Changing or Breaking Links to Data in Tables

  • Article

After linking to some data, you might want to use a different data source, or you might want to embed rather than link. To change the data source, you must change the link; and to embed, you must break the link.

To change the link to data in a General field

  1. Open and browse the appropriate table.

  2. Double-click the General field containing the data whose link you want to change.

  3. From the Edit menu, choose Links. The Links dialog box appears.

    Note   Choose Automatic to automatically update data any time it changes in the source application, or Manual if you want to manually update data.

  4. In the Links dialog box, choose Change Source.

    The Change Source dialog box appears.

  5. Specify the new data source and choose OK.

  6. In the Links dialog box, choose Close to complete the change.

To break a link to data in a General field

  1. Open and browse the appropriate table.
  2. Double-click the General field containing the data whose link you want to break.
  3. From the Edit menu, choose Links.
  4. In the Links dialog box, choose Break Link.
  5. Choose Close.

When the link is broken, the data becomes static.

See Also

Inserting Data in Tables | Displaying Embedded or Linked Data on Forms | Displaying Embedded or Linked Data from Tables | Editing OLE Objects in Forms and Tables | Replacing Linked or Embedded Data with Static Data | Dynamic Information Sharing | Importing and Exporting Data | Adding OLE