[AccessD] Open two MDBs at once

I knew that :-) I was just um testing you :-)

In fact, once I wrote a piece about doing that to 12 different MDBs at once,
all in a single select statement. Sheesh. Doncha love senior moments?

 

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Brett Barabash
Sent: February 5, 2003 11:16 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Open two MDBs at once

 

I believe you are looking for an outer join query:

 

SELECT * FROM tblAccounts 

LEFT JOIN [c:\mdb2.mdb].tblAccounts AS tblAccounts2 

ON tblAccounts.AccountID = tblAccounts2.AccountID

WHERE tblAccounts2.AccountID Is Null;

 

 

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Wednesday, February 05, 2003 10:06 AM
To: AccessD
Subject: [AccessD] Open two MDBs at once

I should know this, but I don't. Assume two structurally identical MDBs, but
their rows differ. The goal is to identify the rows in MDB2 that do not
occur in MDB1; then to present them as a multi-select list; and finally to
import the selected rows into MDB2 from MDB1.

TIA.

A.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030205/64abcf14/attachment-0002.html>