[AccessD] Remote Queries

There are drawbacks.  I don't believe you can specificy a different .mdw or
username/password  with this type of statement.  Also, what if the Backend
is moved?  Instead of having to relink the tables, you'll have to change the
SQL in everything that uses this path.

Drew

-----Original Message-----
From: Dan Waters [mailto:dwaters at usinternet.com]
Sent: Sunday, November 07, 2004 7:41 AM
To: Database Advisors
Subject: [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

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com