ACC2000: How to Simulate Parameters in an SQL Pass-Through Query (232493)
The information in this article applies to:
This article was previously published under Q232493 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
This article demonstrates two sample user-defined Visual Basic for
Applications functions that you can use to pass parameters to an SQL
pass-through query.
NOTE: You can see a demonstration of the technique that is used in this article in the sample file Qrysmp00.exe. For information about how to obtain this sample file, please see the following article in the Microsoft
Knowledge Base:
207626 ACC2000: Access 2000 Sample Queries Available in Download Center
REFERENCES
For more information about the syntax for the SQL property of the SQL
pass-through query, see the documentation for your ODBC database server.
For more information about pass-through queries, click Microsoft Access Help on the Help menu, type send commands to an sql database using a pass-through query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kbhowto kbinfo KB232493 |
---|
|