[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