• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

Sharepoint Access Services - forms failing to load

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.
  • 2
1 Solution
Restart the IIS, SQL- Server and all the Sharepoint Services.
dgmoore1Author Commented:
I'll ask admin to do this Monday - thanks for the tip!
dgmoore1Author Commented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now