Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Not all lookup fields updated in MS-Access sync.

  Asked By: Jan    Date: Aug 29    Category: Sharepoint    Views: 1691

I have an MS-Access database with links to SharePoint lists. The loookup fields are not all updated when I synchronize after I create records offline . I built a test with the following result:

* I created 4 SharePoint lists A, B, C, D. C has a lookup to A and one to B and D has a lookup to A
* I created an MS-Access database with links to A, B, C,
* I created a record in A (ID=-1), in B (ID=-1) and in C (pointing to A=-1 and B=-1)
* I synchronized
* Now all ID's are correct: A and B got ID=1, C points to A (ID=1) and B (ID=1)
* However, when I add D, make D point to A (ID=-1) and repeat the steps above the pointer in D is not updated, but remains -1. A, B and C are updated correctly.

Is this a Sharepoint/Access limitation or is there a way to resolve it?

Thanks a lot for any help.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jan Van bekkum     Answered On: Sep 04

Further test: the problem remains the same when I remove B and the link to it. See attached drawing. https://docs.google.com/drawings/pub?id=1FpV9LKwrxqey0ZMyDsi1m1bddjlfhtohKMPqItYiuRc&w=960&h=720

 
Didn't find what you were looking for? Find more on Not all lookup fields updated in MS-Access sync. Or get search suggestion and latest updates.




Tagged: