Joining two tables from two different database.

Posted on 2003-03-19
Medium Priority
Last Modified: 2010-05-01
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.
Question by:eagle23
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 101

Expert Comment

ID: 8171786
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.

LVL 53

Accepted Solution

Dhaest earned 40 total points
ID: 8172112
Here is an example where you link tables from different MDBs another MDB. you need to specify the full path to the MDB.

SELECT DISTINCT People.LastName, People.PeopleID
FROM ([C:\CODEVB\phonelist].People INNER JOIN [C:\CODEVB\events].regMeeting ON People.PeopleID = regMeeting.peopleID) INNER JOIN [C:\CODEVB\events].Meeting ON regMeeting.meetingID = Meeting.meetingID
WHERE (((Meeting.eventID)=1));

Expert Comment

ID: 8531955
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 for information and options.

Expert Comment

ID: 8982617
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:

Cleanup Volunteer

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses
Course of the Month10 days, 11 hours left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question