I know this is possible, but I'm having trouble finding how to do it. I have an SQL Server table that I need to UNION with an Access table that resides on the same network. I need to do this from within a VB6 application. Can anyone help?
The actual UNION operation needs to be handled at the SQL Server level. Make the Access database available in SQL Server using sp_addlinkedserver and use SQL Server to handle the JOIN operation for you.