Dear Sir,

Data folder has following mdb's

Table1.mdb

mydata.mdb

myinfo.mdb

mydetail.mdb

xyz.mdb

All mdb's have single Table.

The field are same in all Tables like

customer_id

Customer_name

Customer_city

Now I want to search customer_name="Boris" from all tables

Please modify my following query

public con
con = sqlstringconnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=e:\data\...........")
SQLEXEC(con,"select * from ......... where customer_name=?thisform.text1.value", 'Junk1')