<div>
Not to the best of my knowledge.<br />
<br />
If you can open either database directly or build a separate database you can link the outside table. &nbsp;Then you can build an SQL to the 2 tables since they are seeming to be in the same database.<br />
<br />
mlmcc
</div>


Not to the best of my knowledge.

If you can open either database directly or build a separate database you can link the outside table.  Then you can build an SQL to the 2 tables since they are seeming to be in the same database.

mlmcc

<div>
Hi eagle23,<br />
This old question (QID 20556952) needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;Please see <a href="http://www.cityofangels.com/Experts/Closing.htm" rel="ugc">http://www.cityofangels.com/Experts/Closing.htm</a>&nbsp;for information and options.
</div>


Hi eagle23,
This old question (QID 20556952) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm [http://www.cityofangels.com/Experts/Closing.htm] for information and options.

<div>
This question has been classified as abandoned. &nbsp;I will make a recommendation to the moderators on its resolution in a week or two. &nbsp;I would appreciate any comments by the experts that would help me in making a recommendation.<br />
It is assumed that any participant not responding to this request is no longer interested in its final deposition.<br />
<br />
If the asker does not know how to close the question, the options are here:<br />
<a href="https://www.experts-exchange.com/help/closing.jsp" rel="ugc nofollow">https://www.experts-exchange.com/help/closing.jsp</a><br />
<br />
GPrentice00<br />
Cleanup Volunteer
</div>


This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in a week or two.  I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help/closing.jsp [https://www.experts-exchange.com/help/closing.jsp]

GPrentice00
Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
My front end is VB and my backend is MS Access.Is there an SQL statement that can join two tables from two different database or mdb files? If yes,please post the corresponding SQL statement.
</div>
</div>


My front end is VB and my backend is MS Access.Is there an SQL statement that can join two tables from two different database or mdb files? If yes,please post the corresponding SQL statement.

Joining two tables from two different database.

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.