jwcolby
jwcolby at colbyconsulting.com
Mon Aug 27 21:43:36 CDT 2007
Hmmm.. I'll have to study that one. BTW there is a full eclipse of the moon tonight in the US, I think Europe is out of luck on this one. I'll be outside about 5am to see it. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Monday, August 27, 2007 6:46 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] IN clause John, Here is how it works here in Spb, Russia :) IN '' [ODBC;DRIVER=SQL Native Client;SERVER=NANT\SQLEXPRESS;Trusted_Connection=Yes;DATABASE=myDatabase;] Watch out line wraps! This set of lines above is just one source line. Example MS SQL table query using this IN clause: Select * FROM Workstation IN '' [ODBC;DRIVER=SQL Native Client;SERVER=NANT\SQLEXPRESS;Trusted_Connection=Yes;DATABASE=myDatabase;] HTH. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, August 28, 2007 12:52 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] IN clause Can a SQL statement use an IN 'DatabaseName' clause which references a table in a SQL Server database? I know how to do it with an MDB, just place the path in 'DatabaseName' but what do you do if the table is in SQL Server? John W. Colby Colby Consulting www.ColbyConsulting.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