Linking SQL Express 2005 Tables to MS Access 2007
(Page 1 of 5 )
This tutorial shows you how to link tables on your SQL 2005 Express server to an MS Access 2007 database. Some of the salient features of the MS Access 2007 program were discussed in an earlier tutorial including a detailed description of the "Ribbon." Reading the earlier article will help you to go through this tutorial with ease.
Introduction
With Access 2007 you can create read/write linked tables to SQL Server Tables/Views. Linking tables is one of the ways to get access to external data and create front ends without actually having the data locally. If you want to hold on to the table structure and give permission to create front-end applications to others, this is the preferred method of data access. The other methods are copying and importing data. When you link tables which are in an external source you will not be permitted to make changes to the structure of the tables, nor to make design changes to the tables. You may make such changes at the source.
Steps for successful linking
The tables to be linked are on a SQL 2005 Express server. This could be on a connected or a networked machine. In this tutorial it is on the local machine.
A new install of SQL 2005 Express server has only the system databases. Hence a Northwind database was brought into the SQL 2005 Express server using the ExportImport task. The ODBC connection to be described will be made to this database, called Windy. This database has all the tables from the Northwind database.
Next: Creating an ODBC Data Source >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
