<div>
Adjusted points from 50 to 75
</div>


<div>
<br />
<br />
Dim dbsYourDB As Database<br />
Dim qdfTemp As QueryDef<br />
<br />
<br />
Set dbsYourDB = OpenDatabase&quot;Northwind.mdb<wbr />&quot;)<br />
<br />
Set qdfTemp = dbsYourDB.CreateQueryDef(&quot;<wbr />NewQueryDe<wbr />f&quot;, &quot;SELECT * FROM YourTable&quot;)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
dbsYourDB.Close<br />

</div>




Dim dbsYourDB As Database
Dim qdfTemp As QueryDef


Set dbsYourDB = OpenDatabase"Northwind.mdb")

Set qdfTemp = dbsYourDB.CreateQueryDef("NewQueryDef", "SELECT * FROM YourTable")
            
dbsYourDB.Close


<div>
I want to save a query using rdo not DAO object, and this query should be stored in the database for future refence.
</div>


I want to save a query using rdo not DAO object, and this query should be stored in the database for future refence.

<div>
<div class="content wysiwyg-content">
How to save a query using rdo technology?
</div>
</div>


How to save a query using rdo technology?

RDO Query

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.