Hale, Jim
jim.hale at fleetpride.com
Fri May 30 12:49:49 CDT 2003
Another posibility is to store the SQL string in a table in the Access database and retrieve and execute the string as needed. Jim -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Friday, May 30, 2003 10:02 AM To: accessd at databaseadvisors.com Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030530/8242c5a7/attachment-0001.html>