Sharepoint Access Services - forms failing to load

Posted on 2011-05-07
Last Modified: 2012-06-22
I have an Access app under development published to Sharepoint. The app contains 3 data forms and an unbound text form. Until two days ago everything worked correctly, but yesterday when I logged on to Sharepoint the main Navigation Form loaded correctly, but when I select any of the three navigation tabs the corresponding forms fail to load in NavigationSubform - instead I get the error "an error has occurred".

Since nothing in the app or the data had changed, I undertook the following diagnostics:

I first verified that a plain unbound form containing text only (no data or macros) opens correctly in NavigationSubform.

I then removed the source query from one of the forms that would not load. With the form not bound to a table or query and the fields all unbound that form also loads correctly.

I then restored the source query to the form, but bound only one of the fields to the query, leaving the rest of the fields unbound. The form does not load.

I then removed the source query and bound the form directly to one of the tables. Again, the form does not load.

I then tried a second form, which is bound to a different table/query – like the others, it loads correctly when unbound from the recordsource, but fails to load when bound.

It looks like there is some problem with the data on the server. Any suggestions would be appreciated.
Question by:dgmoore1
    LVL 5

    Accepted Solution

    Restart the IIS, SQL- Server and all the Sharepoint Services.

    Author Comment

    I'll ask admin to do this Monday - thanks for the tip!

    Author Comment

    Bingo! Turns out SQL Server had been restarted the day before the problem occurred, and when things were restored "the service" (not sure which one) was not running on the server where it should have been. They got it started and the app is now working.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now