Visual Basic Concepts

Accessing Stored Procedures Using DAO

In some environments, access to server data is limited to a set of server-based stored procedures. In this case, some or all data requests and updates are carried out through these stored procedures — especially when you have no direct access to the remote tables. In such an environment, you must use SQL pass-through queries exclusively or use ODBCDirect if you choose to use DAO. If your server forces all queries and updates to be executed through stored procedures, then you can use SQL pass-through queries to execute the UPDATE stored procedures as well as the SELECT stored procedures. You can then base other Jet QueryDef objects on these queries as if they were attached tables.