Friday, 13 December 2013

Linking Access 2013 to Microsoft SQL Server Part - 1

Introduction:

Hi here I will explain how to Linking ms access database to SQL Server.

Description:

Before Linking MS Access to SQL Server we need to fallow the some steps which is given below.

Step 1: Open your SQL Server => on security tab right click on Login tab hit the New Login.
Step 2: On General tab give a Login Name and select any one of windows/sql authentication and select a database which is shown on below picture.
Step 3: And User Mapping tab check the your database and hit the Ok button.

Step 4: After creating User from sql server go to control panel and double click on Administration Tools.

Step 5: On Administration Tools double click on Data Source(ODBC).

To Continue this Click on Part - 2







No comments:

Post a Comment