In order to do this, you need to: 1. Click Tools 2. Click Remote Data Access 3. Now click Lock Remote Data Access.  4. Make the needed changes within the data at the main site.  5. In order to unlock Remote Data Access, click Tools 6. Now click Remote Data Access  7. Finally click Refresh Remote Data Access 8. Lastly click OK