Linking an Access Table to a new SQL Data Source
Robert Askam
1 min read
3,496 views
Linking an Access Table to a new SQL Data Source
Open Windows Run and paste C:\Windows\SysWOW64\odbcad32.exe
Then click System DSN tab and click add.
Step 1:
Select the SQL Server Native Client 11.0 driver and click OK.
Step 2:
Enter a Name and Description for the Connection.
Enter the address you Remote Connect to your server, click next.
Step 3:
Enter your login credentials you connect to your SQL Server with, click next.
Step 4:
Change the default database to your required database, click next.
Step 5:
Change your logging if required, click next.
Step 6:
Go to Microsoft Access and click on the External Data tab followed by the Linked Table Manager button.
Step 7:
Find the table you wish to change e.g(dbo_testTable (DSN=oldTable;DATABASE=oldTable).
Click the checkbox for Always prompt for new location and click OK.
Step 8:
Click on the Machine Data Source Tab, click on the new connection we made and click OK. This should now update the database for this table.
Posts Access MySQL