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

Web Database in Sharepoint 2010 generates error when displaying data

I had an HTTP 500 error with my Sharepoint 2010 Server which is running on Windows Server 2008 R2. This is resolved under EE  ID# 34997073, however I also have Access 2010 Web Databases published using Access Database services and when I try to open the "Issues" web database I get an "error loading try again" message when it tries to display any Open or Closed issues or if I try to enter any data. Reports work fine.  I created this web database using the Access 2010 Issues Wed database template. I have done this before without a problem. So I think it is related to my other issue I posted on EE referenced above.

I looked at the event log and see "No Access Database Service is available in the farm.[User: wsi\administrator]".  Any ideas on how to troubleshoot this?

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_26849675.html#a34993803
0
AccessYourBiz_Com
Asked:
AccessYourBiz_Com
  • 2
  • 2
1 Solution
 
sabby447Commented:
Hi, Please check if Access database services are running under following :

1. Services on Server in server configuration
2. Application management : Check for service applications, Check if you have a Access services running on this

You should be able to create a new association and point to old db's as needed and it should work fine
0
 
AccessYourBiz_ComAuthor Commented:
Thanks dude, you are the man!!!
Everything is working ok now. I did what you said and check Access Services and they were Stopped so I started them and walla, it worked. Thanks again!!

On the flip side, this experience has made me very nervous about Sharepoint. I am not sure what I even did. Do you think it was Cold Fusion 9 install that disrupted things? Since CF is intergrated with SP I thought it would be ok.
Let me know what you think.
0
 
sabby447Commented:
Hunh, I have not worked personally with Cold fusion thus would not be able to comment. what i could make out of the log. As a best practice i would go with system state backup or virtual machine backup  and site, farm and db backup.. This will atleast give you all the items you need to recover, Let me know if you would like my help on that.. Reach me on sabby777@gmail.com
0
 
AccessYourBiz_ComAuthor Commented:
Thank you very much, I am interested about that. I will send an email, thanks again.
0
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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