[AccessD] ODBC for Access

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




More information about the AccessD mailing list