Integrating SPS Portal Events List to an MS Access Relational DB

[isben22]

I am running SP Portal 2 and MS Access 2003.

Our SPP has a LIST of events that many departments contribute to. I want to use MS Access to develop custom itineraries based off this calendar of events.

Problem: I have linked to the SPS List without trouble, however when it comes to building relationships on an SPS List I am having no luck.

I have tried:
1. Linking to SPS LIST
2. Building a QUERY from a linked SPS LIST
3. Building an UPDATE Query (will not delete an event that falls off calendar)
4. Building an APPEND QUERY – only adds data
5. Building a MAKE TABLE QUERY – Destroys Relationships

Desired Outcome:

I would like to use the SPS Events List Records in MS Access to make a Split database (back end and front end). So that, general users outside immediate office will see the calendar of events, and those that work with the events can use MS access to develop the complex itineraries.

I cannot find enough documentation on integration of SPS Portal 2 and MS Access to make the relations work.

Any suggestions on getting started. I can manage simple VB and functions and have plenty of reference on the subject. But the easier and more accurate the better.

Thanks for your time!
M