Linking Access 2013 to Microsoft SQL Server Part - 3

Introduction:

Here I will explain how to Linking ms access database to SQL Server Part - 3.

Description:
In my previous post I explained how to create odbc connection. here I will explain how to connect MS-Access to odbc connection.

Step 14: Open MS-Access and select blank desktop database.

Step 15: Select Database Location and give database Name to click on create.

Step 16: Under External Data Menu click on ODBC Database.

Step 17: Select Link to the data source by creating linked table and click on ok.

Step 18: On Machine Data source select your odbc connection and click on ok.

Step 19: Enter the password and click on ok.

Step 20: After entering password select which table you have to synchronize.

Step 21: After selecting table click on ok the selected data will automatically populated from ms-access.

Step 22: Finally go to Sql server right click on your database(which is linked db) and go to properties, under permission tab select you odbc connection to give a permissions which you want explicitly.

Happy coding!...

If you have any queries please leave a comment.....