If I change the ODBC DSN from the registry on Windows 7, will the linked tables be updated in MS Access?
If I update the ODBC DSN registry entries to reflect server migration changes, will the linked tables that use them in the local MS-Access databases be updated, or will they just automatically point to the linked tables on the other server? Or does it depend on the driver?
This will apply to both 32-bit and 64-bit systems using the ODBC drivers for Visual Fox Pro (free catalog tables), MySQL, and SQL Server.
The following are the registry paths I understand:
HKLM\SOFTWARE\ODBC\ODBC.INI
The registry path for 32-bit ODBC DSNs on a 32-bit system or 64-bit ODBC DSNs on a 64-bit system.
HKLM\SOFTWARE\Wow6432Node\ODBC\ODBC.INI
The registry path for 32-bit ODBC DSNs on a 64-bit system.
source to share
Linked tables will not see the changes. You must use the "Linked Table Manager" to update the connection data.
See: http://www.addintools.com/documents/access/where-is-linked-table-manager.html
and: http://sourcedaddy.com/ms-access/modifying-linked-tables.html
source to share