Is it possible to access 2 MS Access MDB files from one Query?  If not how
could it be done?
I had an earlier reply suggesting the following but I got errors.

Actual code in query1.sql
select * from socparent  //alias for F:\program files\...\soc.mdb
where "F:\program files\.....\soc.mdb":socparent.parentid
=  "L:\class\info.mdb":pdata.parenid;

Get a
"General SQL error
Syntax error in PARAMETER clause."

A query like this will work in ADO  I have never tried it with the BDE Access
driver

INSERT  INTO TableA
 (Select SomeFields From TableB IN 'C:\MyFolder\MyDatabase.MDB' )
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com