locked
Access services Sync issue RRS feed

  • Question

  • Hi I have a Access 2010 database.am publishing the database into sharepoint services.The database has some linked tables.So Done the below steps.

    1.First i have converted Linked tables to Sharepoint sites.

    2.using External data from Access 2010 i have provided a link to SharePoint site list to Linked tables.

    3.Run the Compatibility checker.

    Finally it is working fine locally.

    If we open the same site in some other system we are getting 'Sync failed".

    Regards,

    Sudhakar

     

    Moderator Note: NEVER say that your question is urgent. ALL questions here are urgent to the person who posted them and there is no reason why your question should be given a higher priority than anyone elses question. If you are really in a hurry PAY for support by ringing Microsoft Customer Support Services. Do NOT post in the forums.

    • Moved by Rick Pennington Friday, December 17, 2010 8:37 PM incorrect forum (From:Microsoft Online: SharePoint Online)
    • Edited by Mike Walsh FIN Monday, December 20, 2010 7:18 AM This is very urgent removed. Moderator Note added.
    Thursday, December 16, 2010 12:30 PM

Answers

  • Hi Sudhakar,

    Thanks to share your post in this forum.

    For the issue that you have encountered, I think that it may due to connection to the database.

    Please the followed steps which may help you fix it:

    1.       Click Start, click Run, type rig edit, and then click OK.

    2.       In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
    Right-click Lsa, point to New, and then click DWORD Value.

    3.       Type DisableLoopbackCheck, and then press ENTER.

    4.       Right-click DisableLoopbackCheck and then click Modify.

    5.       In the Value data box, type 1, and then click OK.

    6.       Quit Registry Editor, and then restart your computer.

    And other useful reference:

    http://blogs.msdn.com/b/gregmcb/archive/2008/03/15/user-profiles.aspx.

    Hope this could help you!

    Leo

    • Marked as answer by Leoyi Sun Thursday, January 6, 2011 8:56 AM
    Monday, December 20, 2010 6:58 AM
  • Your Title says "Access Services".

    Your text says that you are working with SharePoint Services.

    Both can't be true. SharePoint Services (WSS 2.0 or WSS 3.0) does not include Access Services.

    So which is wrong?

    - your reference to Access Services

    or

    - your reference to SharePoint Services ?


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Thursday, January 6, 2011 8:56 AM
    Monday, December 20, 2010 7:21 AM

All replies

  • Hi Sudhakar,

    Thanks to share your post in this forum.

    For the issue that you have encountered, I think that it may due to connection to the database.

    Please the followed steps which may help you fix it:

    1.       Click Start, click Run, type rig edit, and then click OK.

    2.       In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
    Right-click Lsa, point to New, and then click DWORD Value.

    3.       Type DisableLoopbackCheck, and then press ENTER.

    4.       Right-click DisableLoopbackCheck and then click Modify.

    5.       In the Value data box, type 1, and then click OK.

    6.       Quit Registry Editor, and then restart your computer.

    And other useful reference:

    http://blogs.msdn.com/b/gregmcb/archive/2008/03/15/user-profiles.aspx.

    Hope this could help you!

    Leo

    • Marked as answer by Leoyi Sun Thursday, January 6, 2011 8:56 AM
    Monday, December 20, 2010 6:58 AM
  • Your Title says "Access Services".

    Your text says that you are working with SharePoint Services.

    Both can't be true. SharePoint Services (WSS 2.0 or WSS 3.0) does not include Access Services.

    So which is wrong?

    - your reference to Access Services

    or

    - your reference to SharePoint Services ?


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by Leoyi Sun Thursday, January 6, 2011 8:56 AM
    Monday, December 20, 2010 7:21 AM
  • Hi Mike,

    Thanx for ur advice!!!

    Am using Access services to publish access db into SharePoint.

    the normal databases after conversion to SharePoint sites are working fine.

    But the databses which are referring from sharepoint lists are not sync properly.Those are working local(where we converted into sharepoint sites).but the same site is not sync while we opening the same site in other system.Am getting the below error.The sharepoint site is not sync properly.

    send and receive changes with the server

    Attempt to Sync with the server and reconnect all tables.

         changes have not been sent to the server

         changes have not been downloaded from the server

        Regards,

        Sudhakar

     

    Monday, December 20, 2010 11:41 AM