Thursday, December 24, 2009

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. 

No comments:

Post a Comment