Re: SQL In 2 Databases

You could probably create one of the databases to be a master database and
provide a linked table to the other database. This is not something I have
done to very much extent but you should be able to use the Access newsgroups
for specific questions about linked tables...

Couple of threads discussing your issue:
http://www.sitepoint.com/forums/showthread.php?t=101500
http://www.sitepoint.com/forums/showthread.php?t=178119

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/


"Marky" <z@xxxxx> wrote in message
news:JqY4e.3595762$Zm5.579242@xxxxxxxxxxxxxxxxxxxx
> 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!
>
>
>
>


.

Relevant Pages
Loading