locked
Problem with Access and SharePoint RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have been having a problem with Access and SharePoint. After the Access web database is published to SharePoint and I visit the site, I get this error message:

    Site is down

    One or more of the site's Queries, Tables, or Macros were recently changed and failed to compile. The site is down to prevent data issues while these objects are in an invalid state.

    Click here to view the errors in Microsoft Access.

    When I view the errors in Access I see this:

    USysApplicationLog

    ID

    Content Type

    SourceObject

    Data Macro Instance ID

    Error Number

    Category

    Object Type

    Description

    Context

    Attachments

    Modified

    Created

    Created By

    Modified By

    1

    USysApplicationLog entry

    qrySupportedPersons

    Compilation

    Query

    Invalid execution state.

    0

    15/08/2012 11:19:06 AM

    15/08/2012 11:19:06 AM

    Carlton Becker

    Carlton Becker

     

    My table has 71 fields. When I make a query based on all 71 fields in the database, It works in access and I can run the compatibility checker and get no errors, but once I visit the site on SharePoint I get the above error. When the query has roughly under 42 fields I do not get the error on SharePoint, and it works fine. Also if I try making a second query  and try spitting the 71 fields amongst the two queries, I get the same error if the two queries combined have more than roughly 42 fields.

    What is causing this, and how do I fix this?

    Here is a link to the file with some test data:

     

    Wednesday, August 15, 2012 7:27 PM

All replies