Friday, July 9, 2010


Connecting Access To SQL Server

Although Query Analyzer is a useful tool, it’s not all that user-friendly. You need to understand SQL to do much of anything with Query Analyzer. Wouldn’t it be nice to just view your SQL Server data through a more friendly interface? Well, if you’re familiar with Microsoft Access and you have Access 2000 or new , you can do just that.
Tested With Access 2000 And SQL Server 2000
Since Access 2000, Access includes a new type of database called an Access project. An Access project includes all of the familiar Access user-interface tools such as forms and reports. However, instead of storing its data in a Jet database, it stores its data in a Microsoft SQL Server database. In fact, Access even comes with a desktop version of SQL Server, the Microsoft Database Engine (MSDE).

You can also create an Access project that shows data from an existing SQL Server database. To do so, follow these steps:
  1. Launch Access.
  2. Choose Create a New Database Using Access Database Wizards, Pages and Projects from the opening dialog box.
  3. Choose the General tab in the New dialog box.
  4. Choose the icon for Project (Existing Database) and click OK.
  5. Assign a name to your project and click Create.
  6. Enter your SQL Server name, authentication information, and database name in the Data Link Properties dialog box, and click OK.
That’s all there is to it.


About bench3 -

Haja Peer Mohamed H, Software Engineer by profession, Author, Founder and CEO of "bench3" you can connect with me on Twitter , Facebook and also onGoogle+

Subscribe to this Blog via Email :