Ability to link refresh linked table to a server (SQL Server or Oracle) I have no access to
In VBA if I want to change the .connect property to a server where I have no access, the tableDef.Refresh generates an error.
I would like to be able to relink from DEV SQL Server to PROD SQL Server before deployment even when I have no access to PROD
Patrick Honorez commented
Today we have to deploy an app that includes a looong "relink" procedure that the clients must endure at every new deployment. Adding a "NoCheck" option to tableDef.Refresh would allow relinking BEFORE deployment, and also FASTER relink.