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

[NeoPa]

M,

You may get lucky on this one, but as it depends so heavily on specific SPS Portal experience you will need to be.
It's worth posting of course, but we don't always have experts for all the different questions, although we like to think we cover the Access side pretty well.

Good luck anyway.

[isben22]

M,

You may get lucky on this one, but as it depends so heavily on specific SPS Portal experience you will need to be.
It's worth posting of course, but we don't always have experts for all the different questions, although we like to think we cover the Access side pretty well.

Good luck anyway.

From what I understand, this is hard to do. Even on a few sharepoint sites there were not many cross-functional experts. If I find out anything I will post.

thanks!

M

[NeoPa]

Thank you, and good luck again :)
-NeoPa.