Linking SQL Express 2005 Tables to MS Access 2007 - Linking Tables
(Page 4 of 5 )
Choose the second option, Link to the data source by creating a linked table. Clicking on the OK button opens the next window, where you need to select the data source. Here the AccWindy data source will be used. You can also start creating a new data source from here by clicking the New... button, which will open up the ODBC Data Source Administrator window seen earlier. This window opens up with the File Data Source by default; you need to change to the Machine Data Source tab.
When you click on the OK button in the above window you will get the SQL Server Login window, where you need to fill in the login details used during the AccWindy data source creation step.
Fill in the information and then click on the OK button. This opens up the Link Tables window displaying all the available tables in the database.
You can select multiple tables using your mouse by holding down the Shift key. By clicking on the OK button in the above window you will get a number of windows popping up, one for each table you are using, so that you can Select a Unique Record Identifier. This is needed for modifying records in the database. The next picture is a composite of two screens; the top one is showing the process that is taking place and the bottom one is the unique record. Make sure you read the information at the bottom of the screen.
Next: Displaying Linked Tables >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
