How to Connect MS Access with SQL SERVER & Genrate reports in ACCESS in Simple Steps

Open MS Access and Create Database:

 

Click on External Data tab n click on More Click ODBC Database which shows this Wizard

 

select Link to data source..... and click OK:

 

Click New (leave this DSN empty Ignore tester in above image ) :

 

Select SQL SERVER and Click Next: then Browse

  

Write DSN filename(like tester)                                                   

 

on  server: Dropdownlist select your sqlsever name or simply open sqlmanagement n copy paste its server name here as shown in images: 

 

select  database like Pizzanext from database after clicking on check box:

 

here i have selected town table for generating report and my Town table is available in MSACCESS

 

Now, you can Modify SQL database from MS Access :)
"Share your Knowledge!!"
If you like Please Don't forget to Comment.