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