I've created a set of tables in an OpenOffice database called Surveys.odb. I'd like to link or read records from tables in a MS SLQ Server 2005. I've been able to create the connection to the server through OpenOffice but only using a seperate odb file called "RMS Connections.odb".
Can I create a link between the two odb files? I need to lookup transaction details in the MS SQL server from the Surveys.obd.
FYI, I can copy a table from MS SQL Server into the Survey.odb database, but that's less than ideal as the tables can be quite large. Also, how would I automatically update the copied table?