[AccessD] Querying the back end directly

Don't know about speed, but to answer you last question, you can use ODBC to connect to 
all sorts of "databases"  

See http://www.connectionstrings.com/ which has the connection strings for over 50 data 
sources (including Excel and  Text)


On 26 Apr 2013 at 8:40, John W Colby wrote:

> I know that queries can be constructed to use a "SELECT FROM ExternalFileName.Table" kind of 
> syntax.  In other words, not linking a table out in the BE but in the query referencing the external 
> database (or spreadsheet etc) and then a table inside of that.
> 
> First of all I need to know whether that is faster, slower or no difference.
> 
> I need to be able to modify that to modify the location of the back end file.  While I can open the 
> query def and search through the sql for the file name I would really prefer not to.  Is it possible 
> to use this kind of thing using an ODBC connect string?  Or does an ODBC connect string assume a 
> database server / engine at the other end?
> 
> -- 
> John W. Colby
> 
> Reality is what refuses to go away
> when you do not believe in it
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>