[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