2

How do I change the connection string of a linked table in Access 2010? I don't want to do it programmatically but through the interface. When I try to change it via the table's Properties I get the following message:

enter image description here

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418
Robert
  • 1,638
  • 7
  • 34
  • 45

1 Answers1

2

You can change the connection of one or more linked tables by using the "Linked Table Manager" on the "External Data" tab:

LinkedTableManager.png

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418