On Using Pass-through Queries in MS Access - Creating a Query
(Page 3 of 4 )
The connectivity was established as per the previous procedure. We must now create a SQL query. Open the query in design view, type in a SELECT query as shown here, and close the window.
You will see the Select Data Source window once again.
Select MSClient.dsn and click on the OK button. You will again get a SQL Server Login screen as shown.
When you enter password information and click on the OK button you will see the result of running the query as shown.
Since the connection information is not completely stored with the query, every time the query is run, you need to supply the connection information. This means accessing the Select Data Source window, choosing your dsn and providing login information.
Next: Saving Connection information with the query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
