Linking Multiple Queries and a SharePoint List

G

GLT

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharepoint not capturing staff name when automation runs 0
No option to create a list in SharePoint Site 0
How to Submit rows of a repeating table to a SharePoint list 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy data from SharePoint list to InfoPath Form 0
infopath to sharepoint list 0
Access Query to import from Sharepoint 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1

Top