Page 1 of 1

LinkExternalTable functionality

Posted: Wed 07 Aug 2013 20:29
by bwilt
Hello,
We have UniDac 5.0.1 which is connected to two MDB databases.

Previously we had used a LinkExternalTable() function to link into the main database a table from the second database.

We then performed a SELECT + INNER JOIN on the link table and external table.

Is there a way of performing this type of functionality ?

Re: LinkExternalTable functionality

Posted: Thu 08 Aug 2013 10:10
by AlexP
Hello,

Unfortunately, there is no method in UniDAC similar to LinkExternalTable

Re: LinkExternalTable functionality

Posted: Thu 08 Aug 2013 21:04
by bwilt
Hi Alex,

So is it possible to load two database i.e. two UniConnection + UniTables.

Then do a INNER JOIN between these two database's and tables ?

Both tables have the same structure.

Re: LinkExternalTable functionality

Posted: Fri 09 Aug 2013 09:29
by AlexP
Hello,

You can add the needed table to the database as a Link Table by means of MS Access. After this, the table will be available in UniDAC