[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Web Database in Sharepoint 2010 generates error when displaying data

Posted on 2011-02-28
4
Medium Priority
?
737 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
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 viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

650 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