<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Saving Query From VB6 into Access</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Another posibility is to store the SQL string in a table in the Access database and retrieve and execute the string as needed.</FONT></P>
<P><FONT SIZE=2>Jim</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Charlotte Foust [<A HREF="mailto:cfoust@infostatsystems.com">mailto:cfoust@infostatsystems.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, May 30, 2003 10:02 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Saving Query From VB6 into Access</FONT>
</P>
<BR>
<P><FONT SIZE=2>You don't ordinarily save queries in back end databases, but you can add</FONT>
<BR><FONT SIZE=2>a query to the catalog (ADOX) or querydef (DAO) object to the Access</FONT>
<BR><FONT SIZE=2>database programmatically using the SQL you have created. Which kind of</FONT>
<BR><FONT SIZE=2>connection are you using? The code differs quite radically between the</FONT>
<BR><FONT SIZE=2>two.</FONT>
</P>
<P><FONT SIZE=2>Charlotte Foust</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: paul.hartland@fsmail.net [<A HREF="mailto:paul.hartland@fsmail.net">mailto:paul.hartland@fsmail.net</A>] </FONT>
<BR><FONT SIZE=2>Sent: Friday, May 30, 2003 12:20 AM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com; dba-vb@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] Saving Query From VB6 into Access</FONT>
</P>
<BR>
<P><FONT SIZE=2>To all,</FONT>
</P>
<P><FONT SIZE=2>I'm sure I have either done this before or have heard it can be done. I</FONT>
<BR><FONT SIZE=2>have a Visual Basic 6 front-end which links to an Access back-end, what</FONT>
<BR><FONT SIZE=2>I want to do is build a SQL select statement on the fly in VB6 (I have</FONT>
<BR><FONT SIZE=2>got this far), and then I need to save it as a query into the Access</FONT>
<BR><FONT SIZE=2>database.</FONT>
</P>
<P><FONT SIZE=2>Anyone have any ideas on how I go about this.....</FONT>
</P>
<P><FONT SIZE=2>Thanks in advance.</FONT>
</P>
<P><FONT SIZE=2>Paul </FONT>
</P>
<P><FONT SIZE=2>________________________________________________________________________</FONT>
<BR><FONT SIZE=2>__</FONT>
<BR><FONT SIZE=2>Join Freeserve <A HREF="http://www.freeserve.com/time/" TARGET="_blank">http://www.freeserve.com/time/</A></FONT>
</P>
<P><FONT SIZE=2>Winner of the 2003 Internet Service Providers' Association awards for</FONT>
<BR><FONT SIZE=2>Best Unmetered ISP and Best Consumer Application.</FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>