.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

attach access database in SharePoint 2010 service application

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#
 

I am planing to publish Access database MyDB into Access Service application in SharePoint 2010 server farm. MyDB has following tables,

tblShared1, tblShared2, tblShared3, tblShared4, ... 

Is that possible for each user to open an Access database locally and set linked tables above in MyDB Access database? If yes, how it works?

Thanks in advance,    





View Complete Post


More Related Resource Links

problem rename sharepoint 2010 search service application admin database

  
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

  
After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

SharePoint 2010 Search Service Application: "All Content" scope contains 0 items?

  
I've encountered a nasty bug in our setup. Our Search Service Application manages to crawl all content just fine. However, the scopes don't work. We've got a total of 570 items currently in our crawl database. 350 of these are of class 'People', and appear in the 'People' scope. The remaining 220 items should appear in 'All Content' as part of the intra (sites, documents etc), however the 'All Content' scope reports 0 items. I've tried the following: -Creating custom scopes (still 0 items) -Recreating the Search Service Application twice -Tried different accounts as the content access account. -Ensuring that the content access accounts do have 'full read policy' -Checked the crawl log for successful content (such as sites and documents). However, despite my efforts I still get 0 items for 'All Content'.  Has anyone else encountered this problem, or do you have any recommendation for us? Currently I don't see any other option than to reinstall everything.

How to Programatically SetCredentials for Secure Store Service Application in Sharepoint 2010 using

  
I have to setup Credentials for Secure Store Service application programatically. To get Stored Credentials I have following code and its working fine. using (SPSite site = new SPSite("http://vtlssp2010Dev")) //using (SPSite site = new SPSite("http://" + System.Environment.MachineName + "/sites/Site_Name"))d { Console.WriteLine(site.RootWeb.CurrentUser.Name); SPServiceContext context = SPServiceContext.GetContext(site); prov.Context = context; try { SecureStoreCredentialCollection cc = prov.GetCredentials(appID); foreach (SecureStoreCredential c in cc) { IntPtr ptr = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(c.Credential); string sDecrypString = System.Runtime.InteropServices.Marshal.PtrToStringUni(ptr); Console.WriteLine(sDecrypString); } } catch (Exception ex) { Console.WriteLine("Unable to get credentials for application " + appID); Console.WriteLine(ex.Message); } Console.ReadLine(); } } All I want is to programmatically do set credentials like explained in this example on msdn. http://msdn.microsoft.com/en-us/library/ff798456.aspx Please help. Shamshad Ali  

Search Service Application missing in SharePoint 2010

  
I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manage services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?

Search Service Application missing in SharePoint 2010

  
I installed SharePoint 2010 (Enterprise edition), enabled Enterprise features but it is missing Search Service Application when I look under Central Administration > Application Management > Manage Service Application.   When I click on New it doesn't even list "Search Service Application".    When I goto Upgrade and Patch Management > Check Product and Patch Installation Status, it tells me that "Microsoft Search Server 2010 Core" was Installed.  Under Manager services of server, "Sharepoint Foundation Search" is started.  Does anyone have an idea why the "Search Service Application" is missing and how can I install it?

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

  
I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

SharePoint 2010 -Shared service Application

  
Hi ,   Can yoy provide me an article to manually configure services one by one in SharePoint 2010 farm?   Best Regards, Garima

Publish Access 2010 Database to Sharepoint 2010

  

We have been unable to publich our Access Databases to sharepoint. I have created a new table with 2 fields, called field1 and fields. I then created a new form to list both views, taking all the defaults. I then clicked on File -> Save & Publish -> Publish to Access Services. Entered our sharepoint site and a name Test. When I try to go to the site I get the following errors. I am not sure where to go from here. We have tried both access databases and web databases.

Site is down
One or more of the site's Queries, Tables, or Macros were recently changed and failed to compile. The site is down to prevent data issues while these objects are in an invalid state.
Click here to view the errors in Microsoft Access.

USysApplicationLog
ID Content Type SourceObject Data Macro Instance ID

Is SharePoint and Access 2010 the right platform for subscription based web application?

  

Hello,

I posted a similar question in the Access Form and the MVP's there suggested I post a follow up here, to clarify the SharePoint issue. 

My Question: is SharePoint and Access 2010 a good platform, or can it do what I need?

The Scenario:

I currently have a client/server app built in Access 2002 with many clients in a single industry. My clients are very mobile and would like to be able to do their work in the app anywhere, not just while connected to the office network. Likewise, a large percentage in that industry have Macs (I've used Windows in Parallels or Fusion for these clients but it's not a smooth process, in a lot of 'connectivity' ways). My clients are asking, and my competition already has, web based applications. I very much need to get my app on the web. Along with that, I need to set it up as a monthly subscription based application.

 

So I'm hoping Access and SharePoint can do this. I don't know ASP or PHP or SQL so it'd be a steep learning curve if I have to go that route. I don't know much about SharePoint but have watched videos about using it for Access Web databases as well as RichClient/SharePoint Lists. 

It's possible I could have over 1000 clients, each of which will have a few thousand records in the main few tables (SP Lists). Each client could also have several users l

Cannot Publsih to SharePoint 2010 with Access 2010 Web Database

  

When I try and publish a Microsoft Access 2010 web database I get the following error message:

“http://win-qbrhOmjl8it:32728/teaml/SitePagesfHome.aspx/ “did not respond.  Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older

version of Microsoft Access Services that is not compatible with Access 2010.

 

My step by step is as follows:

I open Microsoft Access 2010 and open a sample templates such as the Assests Web Database and then I create the file and it saves locally by default to C:\Users\Larry\Documents\Assets Web Database3 it then prepares the template and ask me for a User Login

Cannot Publsih to SharePoint 2010 with Access 2010 Web Database

  

When I try and publish a Microsoft Access 2010 web database I get the following error message:

“http://win-qbrhOmjl8it:32728/teaml/SitePagesfHome.aspx/ “did not respond.  Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older

version of Microsoft Access Services that is not compatible with Access 2010.

 

My step by step is as follows:

I open Microsoft Access 2010 and open a sample templates such as the Assests Web Database and then I create the file and it saves locally by default to C:\Users\Larry\Documents\Assets Web Database3 it then prepares the template and ask me for a User Login

Sharepoint 2010 Error "You do not have permissions to access a database"

  

Hi,

When I click a button in a form (designed by Infopath 2010,custom code included,full trust security,deployed and activated by our sharepoint admin)

An error pops out saying:

"You do not have permissions to access a database that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Log ID:5566

Correlation ID:9161ac7c-7b8f-4164-907a-14426c54b24f"

How

Sharepoint 2010 Error "You do not have permissions to access a database"

  

Hi,

When I click a button in a form (designed by Infopath 2010,custom code included,full trust security,deployed and activated by our sharepoint admin)

An error pops out saying:

"You do not have permissions to access a database that contains data required for this form to function correctly.
An entry has been added to the Windows event log of the server.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Log ID:5566

Correlation ID:9161ac7c-7b8f-4164-907a-14426c54b24f"

How

Access Service available for SharePoint Foundation 2010?

  

Dear all,

I was very excited about the new feature of Access 2010 to deploy an entire Access Application to SharePoint. We are a smaller company and have only SharePoint Foundation 2010 running, not SharePoint Server. Now I had to find out, that in SharePoint foundation the Access Service is not available. I know that single tables/lists still can be deployed from Access to SharePoint, but I was hoping that the Access Service somehow can be plugged in or setup also for SharePoint Foundation 2010. 

So my question is if there is any way, to have the full Access Service Features available also in SharePoint Foundation 2010? 

Thanks a lot and regards,

David


Published Access 2010 Database to Sharepoint 2010. You do not have permission to view the records.

  

I have published an Access 2010 database to Sharepoint 2010.  It is pretty basic and essentially it is just used for teachers to enter lesson plans.  When viewing the site there is a form that has several dropdown menus.  The user should be able to choose their name, date, etc. from these dropdown menus.  The problem is that when I click on a dropdown menu the menu just shows a message that says "This service isn't available right now".  I also get a message that pops up which says "You do not have permission to view the records.  To obtain permission contact your site administrator."

The weird thing is that when I was testing this at one point I clicked the dropdown menu and it did work.  I clicked off the dropdown menu and went right back to it again and it didn't work.

I have anonymous access enabled for this site.  However, I have tried it with an anonymous user as well as with the user account that installed Sharepoint and published the database to Sharepoint and it doesn't work either way.

Is this a permission issue on the site or something else?  Any help is greatly appreciated.


Access denied when Searc Service Application tries to crawl Sharepoint content

  

I have just set up a new SP2010 environtment(3 servers: WFE, App, SQL).

When I try to get my Search Service Application to crawl my main SP site and my MySite location, I get the following error in the crawl log:

"Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled."

Things I have checked:
-
I have ensured that the default access account has "Full Read" on the web application
-I set up crawl rules for both sources specifying a service account that has admin access to the content on those sites
-I logged in to the SP sites using the service account that the Service Application is using to crawl
-I even created a brand new search service application from scratch and got the exact same results

The only difference between this environment and my test environment, where search works just fine, is that this is the production environment and so it uses FQDN with a host header: http://portal.company.org.

Help!


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend