Mike & Doris Manning
mikedorism at verizon.net
Thu Jul 7 10:56:55 CDT 2005
For those that weren't copied, you will have to cut/paste or manually create them because you need to examine why they didn't port over. In most of my cases, it boiled down to a parameter issue between how Access does things and how SQL does them. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths, Richard Sent: Thursday, July 07, 2005 10:53 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access queries to SQL Thanks but only 3/4 out of 40+ of my procs/queries where copied -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: 07 July 2005 14:29 To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access queries to SQL You can upsize the database to SQL and then use the upsize report results to review all the queries that didn't make it. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Griffiths, Richard Sent: Thursday, July 07, 2005 8:09 AM To: AccessD Subject: [AccessD] Access queries to SQL Hi Is there a way of exporting Access queries into SQL (the import from SQL seems to over look the queries - is this correct?) _ I have a system that has many queries and I preferable wish to avoid cut and paste. I used to have a program (downloaded from somewhere) that would having specified an mdb produce code that created/recreated the completed db (tables etc) - can't find this - anyone else come across this? Thanks Richard -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com