PC Review


Reply
Thread Tools Rate Thread

Add field to Access view of Sharepoint database

 
 
LMB
Guest
Posts: n/a
 
      6th Jan 2010
My company has a project database in Sharepoint 2007. There is one record per
project. I have no control over the Sharepoint database. I set up a personal
Access 2007 database (on my Crive) to view and update the Sharepoint data.
I want to add a comments field associated with the project record in my own
Access database for my personal use. However, the table design is frozen
since it's Sharepoint. How can I add the personal comments field and keep it
linked to the project record?
 
Reply With Quote
 
 
 
 
GBA
Guest
Posts: n/a
 
      6th Jan 2010
sure that's a simple 1:1 table relationship

make a local table; include a field that is the cross referencing ID to the
other table from sharepoint...

make your comment form sourced on your new table and make it a subform with
the linking on that cross referencing ID - should work great.


"LMB" wrote:

> My company has a project database in Sharepoint 2007. There is one record per
> project. I have no control over the Sharepoint database. I set up a personal
> Access 2007 database (on my Crive) to view and update the Sharepoint data.
> I want to add a comments field associated with the project record in my own
> Access database for my personal use. However, the table design is frozen
> since it's Sharepoint. How can I add the personal comments field and keep it
> linked to the project record?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving Access Database to Sharepoint Jphillip Microsoft Access 4 7th Jul 2009 06:57 PM
Access Database SharePoint and Protection NapTime Microsoft Access Getting Started 2 13th Jan 2009 11:44 PM
access database and sharepoint list Ann Microsoft Access 0 11th Mar 2008 01:59 PM
Database Connection to Access - Sharepoint Designer =?Utf-8?B?S2V2aW4=?= Microsoft Frontpage 0 3rd Jul 2007 05:34 PM
Re: Cannot access explorer view of sharepoint doc library Robert Aldwinckle Windows Vista General Discussion 2 29th Mar 2007 04:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:42 PM.