[AccessD] Saving Query From VB6 into Access

You don't ordinarily save queries in back end databases, but you can add
a query to the catalog (ADOX) or querydef (DAO) object to the Access
database programmatically using the SQL you have created.  Which kind of
connection are you using?  The code differs quite radically between the
two.

Charlotte Foust

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Friday, May 30, 2003 12:20 AM
To: accessd at databaseadvisors.com; dba-vb at databaseadvisors.com
Subject: [AccessD] Saving Query From VB6 into Access


To all,

I'm sure I have either done this before or have heard it can be done.  I
have a Visual Basic 6 front-end which links to an Access back-end, what
I want to do is build a SQL select statement on the fly in VB6 (I have
got this far), and then I need to save it as a query into the Access
database.

Anyone have any ideas on how I go about this.....

Thanks in advance.

Paul 

________________________________________________________________________
__
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for
Best Unmetered ISP and Best Consumer Application.


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com