>I want to join (inner join and or Left / Right Outer Join) 2 tables but they are not in the same MDB.. how to do this?, thanks in advance for any suggestions..
You should link one the database to the other. Almost all databases engine gives you this feature. All data stays in there respective database but data can be accessed as if it was local from the database who link the other.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com