On Using Pass-through Queries in MS Access - Providing the ODBC Connectivity information
(Page 2 of 4 )
Double click the icon to open the Select Data Source window as shown.
Click on New... to open the next window.
In the Create New Data Source window, scroll down and select SQL Native Client . We will connect to a Northwind database on the SQL 2005 server. Make sure the SQL Server is on. Click on Next to see the following window.
Provide a name to the source, MSClient, and click Next. You will see a summary of your actions thus far in the next window.
Click Finish. This opens up the next window.
Here you provide a description for your datasource as shown, and from the drop-down select HODENTEK (the name of the machine on which the SQL 2005 server is installed). Click Next. In the following window provide the SQL authentication information. If your system accepts Windows NT authentication you can just click Next.
Click Next after typing in the password and Login ID. In the next window, choose "Northwind" from the databases, since the default is "master;" accept the other defaults.
Click Next. In the next window you may change information regarding the log file. Here defaults are used.
Click Finish. This takes you to the final summary screen where you may test the connectivity. You should immediately see the test results.
Click OK twice, once for each open window. You will return to the Select data Source window where you can now see your file data source, MSClient.dsn.
When you click on the OK button, you will get a login screen where you must again type in the login info.
When you click on the OK button after entering the required information, you may get an empty window for the passthru query. This is because there is no query statement in the design view.
Next: Creating a Query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
