?
Solved

Web Database in Sharepoint 2010 generates error when displaying data

Posted on 2011-02-28
4
Medium Priority
?
739 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 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
This video teaches users how to migrate an existing Wordpress website to a new domain.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.
Suggested Courses
Course of the Month14 days, 19 hours left to enroll

839 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