Solved

Web Database in Sharepoint 2010 generates error when displaying data

Posted on 2011-02-28
4
729 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now