Linking Multiple Queries and a SharePoint List

Hi,

I have an Access 2007 Database (MyDB) which connects to an enterprise
database (EnDB) using an ODBC connection.

MyDB extracts a list of servers from the EnDB that have an error status, and
appends (no duplicates) any records found into MyDB. All works well.

I then have another query that cross-checks MyDB against the EnDB for any
servers listed in MyDB where the error no longer exists in the EnDB, and if
any are found it flags a feild in my local databse. I use two queries to
acheive this - 1) Find unmatched Query, 2) Update Query (using the data
produced in the Find Unmatched Query). This also works well.

In essence, there are multiple queries being run to acheive this, and what I
would like to do is connect the table in MyDB to a SharePoint list, and
everytime the Sharepoint List is accessed, these queries run, update all
relevant data, and then data is displayed in SharePoint.

I'm guessing here I need to somehow reduce all three queries into one, and
then connect that to a SharePoint list.

Does anyone know how to acheive this?

Cheers,
GLT.