[AccessD] Remote Queries

Has anyone had experience with what is called a Remote Query?

 

This is where you write the complete path to a table in the Select statement
for a recordset or a form or report recordsource.

 

An example:

 

"SELECT * FROM tblProcessMain" _

            " IN 'C:\Databases\Process.mdb'" _

            " WHERE ProcessStage <> 'Closed'"

 

Using a remote query means that a Front End doesn't need to link to a Back
End.  It also allows a Front End to be distributed without table links and
queries - thus hiding the location of the Back End.

 

This is new to me!  What might be the pros/cons/problems with using Remote
Queries?

 

TIA,

Dan Waters

ProMation Systems