MS Access linked to Sharepoint List GoTo Record acNext problem (1 Viewer)

bconner

Registered User.
Local time
Yesterday, 18:32
Joined
Dec 22, 2008
Messages
183
Hi All,
I have an 2010 Access db linked to sharepoint lists. I have a form users use to update the lists and when they click Save (code below) some users are prompted with the windows security dialogue box prompting them to enter their credentials. When they enter their credentials the security dialogue box just remains. The database appears to be saving their changes but I can't get the security dialogue box to stop popping up. Any ideas?

Code:
Private Sub cmd_Save_Click()
DoCmd.GoToRecord , , acNext
cmb_Task_List = Null
End Sub
 

GohDiamond

"Access- Imagineer that!"
Local time
Yesterday, 19:32
Joined
Nov 1, 2006
Messages
550
Make sure the users that are allowed to write to the lists on SharePoint are members of the site where the lists live and have been given that R/W permission level in SharePoint.

Cheers!
Goh
 

Users who are viewing this thread

Top Bottom