New answers tagged access
The problem is not your configuration but the "My site" itself. Basically, once the "My site" is created, its URL is stored in SharePoint config and content database. And you cannot change it anymore. For internal access, you may not encounter issues as SharePoint can rely on AAM but also on Server name. But from outside your network, you cannot avoid going ...
I would place a VBA event module in a form (can't tie event modules to tables in access) that you commonly use. Private Sub Form_Load() CurrentDb.TableDefs("Table1Name").RefreshLink CurrentDb.TableDefs("Table2Name").RefreshLink End Sub
Top 50 recent answers are included