Edward Zuris
edzedz at comcast.net
Fri Mar 18 22:43:01 CDT 2011
Thanks. That idea works. . . -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, March 18, 2011 5:27 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ODBC for Access Instead of ODBC, can you use the IN keyword? Dim stgFullPath as string Dim stgSQL as string stgFullPath = "//Server/Folder/DataTables.mdb" stgSQL = "SELECT * FROM tblMain IN '" & stgFullPath & "'" _ & " WHERE ID = 1" I use this frequently - avoids table links between access files, and performs well. HTH! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward Zuris Sent: Friday, March 18, 2011 6:10 PM To: accessd at databaseadvisors.com Subject: [AccessD] ODBC for Access Hello Everyone, It has been awhile. I am trying to set am Access DB as an ODBC source and then link tables into another Access database. I did something like that ages ago in Access-97, but seem to have forgotten how to do the same for Access 2000, or Access 2003. Any suggestions on how to do that ? Also is there a selection of ODBC drives out there ? Thanks. Sincerely, Ed Zuris. -- 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