Importing Data into MS Access with ODBC - Configuring the New Data Source to MSDE
(Page 4 of 6 )
This brings us to the next window, Create a New Data Source to SQL Server, where you type a name for the ODBC data source you are creating. Here it is called LinkTut. You may give a description; here it is the title of this tutorial. Now click on the drop-down after the label, Which SQL server do you want to connect to?:. This should show all the available servers, here the XPHTEK/Test instance of the MSDE database is chosen. Click Next.
The window shown next pops up. In this window you need to choose the way you desire to get authenticated. There are two options, Windows integrated authentication, or SQL Server authentication. Whereas for the former you require a network logon, for the latter you require a login name and password recorded in the SQL Server to which you are connecting. Here the former is chosen. You may also place a check mark to use other default configuration settings. Click next.
In this screen, the default database master is brought up, but you can alter the default database. Here a database called myPubs has been chosen. You may accept the other defaults. Click Next.
There are a number of settings which set up various options, but defaults are good enough for this tutorial. Click Next and then click Finish to the window that shows up. You will come to the final window shown after the next picture. The picture shows all the configurational values you chose as well as those from the accepted defaults. If you find that the defaults are not the ones you want, you may edit the configuration settings by going through the same steps.
Finishing touches and testing the connectivity
You may test the connection and then click OK. The window that pops up shows LinkTut as a new DSN under the Machine Data Source tab as shown. Now click OK to this screen.
Next: Importing the tables from MSDE >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 24 
