[AccessD] IN clause

jwcolby jwcolby at colbyconsulting.com
Mon Aug 27 18:04:50 CDT 2007


Bueno, thanks for that. 


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 Doris Manning
Sent: Monday, August 27, 2007 5:41 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] IN clause

Server.dbo.TableName

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, August 27, 2007 4:52 PM
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




More information about the AccessD mailing list