For SQL Server, tables, views and stored procedures are the objects working with Database Exchange. Once the connection established, the Database Exchange control retrieves the schema and list tables and views on the Data Table list, and stored procedures on the Stored Procedure list. You should select the type of record source you want by using the properties form.
The examples use Northwind, which is an example SQL database normally shipped with MSDE or the full version of SQL Server. The examples illustrate the following:
Using a stored procedure as a record source
Changing parameters of a stored procedure at runtime
Using SQL statements as a record source
Using a table or view as a record source