Doris Manning
mikedorism at verizon.net
Mon Aug 27 16:41:05 CDT 2007
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