Results 1 to 2 of 2
  1. #1
    vijayaganesh is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    2

    #ERROR message appears on Sharepoint linked MS access


    Hi All,
    I have created a Asset database using MS Access 2010 & the same was published in SharePoint portal. Post publishing, all the "Query & Forms" are working as excepted but the "Reports" are not working.
    Issue:
    The "Reports" is designed with the help of "Group & Sort" option. Post grouping am able to see the "=Sum([Expression])" (i.e. Sum of the Value) value in MS Access Locally but not in SharePoint. Once i published in SharePoint, am getting "#Error" message for all the below expression wherever i have used in my reports design.
    Please note, I need your assistance in resolving this.
    Expression Used:
    Below expressions are works fine locally & getting #Error in SharePoint.
    1. =Sum()
    2. ="Page " & [Page] & " of " & [Pages]
    3. =Now()
    4. =Date()

  2. #2
    vijayaganesh is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    2
    Hi All,

    May i get some assistance pls...

    Regards,
    VJ

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Excel files on sharepoint linked to access
    By Bertrand82 in forum Access
    Replies: 3
    Last Post: 01-31-2013, 11:57 PM
  2. Linked Tables Giving Error Message
    By 18ck in forum Access
    Replies: 2
    Last Post: 11-23-2012, 06:30 AM
  3. Replies: 3
    Last Post: 05-30-2012, 01:43 PM
  4. Replies: 1
    Last Post: 03-25-2012, 01:53 PM
  5. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums