Re: SQL In 2 Databases

In message <JqY4e.3595762$Zm5.579242@xxxxxxxxxxxxxxxxx>, Marky <z@xxxxx>
writes
>Hi Group
>
>I was wondering how i could get my simple SQL query to check through 2
>databases?
>Both databases are in c:\data\
>Called maindata.mdb & backdata.mdb
>both need to be search in table2
>
>My SQL is currently just "Select * From Table2"
>
>Any ideas?
>
>Thanks!
>

The only way I can see you achieving this in Access would be:

1. In maindata import / link the tables in backdata.
2. In maindata define a new View / Query which joins the real Table2
with the Linked Table2.
3. Change your query to use the new View.

If you had used MSDE or SQL Server then this would have been easy (even
if the databases resided on different PC's).

--
Andrew D. Newbould E-Mail: newsgroups@xxxxxxxxxxxxxxxxx

ZAD Software Systems Web : www.zadsoft.com
.