Solved

Web Database in Sharepoint 2010 generates error when displaying data

Posted on 2011-02-28
4
731 Views
Last Modified: 2012-05-11
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
Comment
Question by:AccessYourBiz_Com
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
sabby447 earned 500 total points
ID: 34997400
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
 
LVL 3

Author Closing Comment

by:AccessYourBiz_Com
ID: 34997595
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
 
LVL 6

Expert Comment

by:sabby447
ID: 34998527
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34998601
Thank you very much, I am interested about that. I will send an email, thanks again.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
JavaScript waiting 14 84
sharepoint 2013 calculated column error 5 40
setup wamp server for first time 2 83
PHP Curl to output a url 7 49
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This video teaches users how to migrate an existing Wordpress website to a new domain.
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

830 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