[AccessD] Access queries to SQL

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





More information about the AccessD mailing list