I have Lotusscript code that connects to a Microsoft Access database using an Oledb connection (Dim con As New Lcconnection(“oledb”)). Is it possible to create a second connection and run SQL that joins tables from two different connections?
Thanks in advance.
Subject: Two oledb connections
I’m going to get around this by creating a query in one of the Microsoft Access databases that points to the table in the other Microsoft Access database. Then, I’ll reference the query instead of the table in my lotusscript. Not ideal because the query has to be hardcoded with the other database path/filename, but seems to be the only way at this point.