By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Integrating SPS Portal Events List to an MS Access Relational DB

isben22
P: 13
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
May 10 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,485
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.
May 15 '07 #2

isben22
P: 13
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
May 22 '07 #3

NeoPa
Expert Mod 15k+
P: 31,485
Thank you, and good luck again :)
-NeoPa.
May 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.