Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

Joining two tables from two different database.

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.
1 Solution
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.

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));
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.
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now