How to use ADOX to create an SQL pass-through query in Access 2002 or in Access 2003 (304323)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
This article was previously published under Q304323 Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY This article shows you how to create an SQL pass-through
query in Microsoft Visual Basic for Applications (VBA) with Microsoft ActiveX
Data Objects (ADO). REFERENCES For more information about Microsoft OLE DB properties,
visit the MSDN Library at the following Microsoft Web site: In the Contents tree in the left pane of the MSDN Library, browse
to the following Help topic:
\Data Access
\Microsoft Data Access Components
\ADO
\SDK Documentation
\Microsoft ActiveX Data Objects (ADO)
\ADO Programmer's Guide
\Section V: Appendixes
\Appendix A: Providers
\Microsoft OLE DB Provider for Microsoft Jet
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbQuery KbVBA kbADO kbhowto KB304323 |
---|
|