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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

Cannot load Access database from SharePoint into client access

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :SharePoint
 

I'm starting to think this is a bug but here's what happens...

We've just deployed Access Services and are testing it.  I've created a new database on my mysite and can edit it fine via the web interface.  However, if I click Options --> Open in Access, I'm presented with this error message:

"Microsoft Access could not open the Web Application from https://mysite.moss.domain.tld/personal/tim/projects.  Please verify that the server is available."

The server is definitely available.  I'm at a loss here.  I'm using Access 2010.




View Complete Post


More Related Resource Links

SQL and Outlook: Enable Database Access and Updates Through Exchange and Any E-mail Client

  

Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002


Usage of Client Access Policy and crossdomain xml for sharepoint 2010>?

  

Hi Folks,

1.What is Clientaccesspolicy.xml in sharepoint ?

2.What is Crossdomain.xml ?

What is usage of wcf service deploy in sharepoint 2010?

Kindly give me some valuable comments ?

 

Thank you

Regards

Immanuel c

 


Sharepoint site client access denied

  

I have an sharepoint application which was working fine.

I encountered a license expired message in sql server enterprise evaluation 2008 version after which i changed the date to 2 months earlier date, I have also changed HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState to 3 after which sql server started working but the issue is that the clients are unable to access the sharepoint site completely. On providing the url the web site requests for logon information and then access is denied. The same url with the same authentication credentials is accessible from the server and the entire application works fine from the server. 

From the  client the below error page appears.

You are not authorized to view this page

You do not have permission to view this directory or page using the credentials that you supplied.


Please try the following:

  • Contact the Web site administrator if you believe you should be able to view this directory or page.
  • Click the Refresh button to try again with different credentials.

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)


Techni

Video: The Access Show: Client Performance Improvements against SharePoint Lists

  
Today's guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance. (Length: 13:05)

Access database using client credentials

  
I have created a small wcf project that comprises the following  TZ_PI_Interface_WCF - This is a WCF service hosted in IIS  TZ_PI_Interface_Client - This is a test client The service is running in as much that my client communicates with it and executes code in the service. My client app executes the GetProcessData_GetSearch_Client_Detail of my service.  This method should go off to a database and return some data to the client. For the purposes of this test I am catching exceptions in the GetProcessData_GetSearch_Client_Detail method and returnind the error message as a piece of data. When the GetProcessData_GetSearch_Client_Detail is executed, a connection should be made the a database and data should be returned to the client The results I get depend on my connection string. These are the scenarios I am trying along with the results of executing GetProcessData_GetSearch_Client_Detail 1) Local DB Test using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user 'N075650\ASPNET' 2) Local DB Test using SQL Login  Data correctly returned 3) Remote DB using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user '(null)' 4) Remote DB using SQL Login  Data correctly returned In the live environment I will have the service hosted on an IIS server (6.0) and the

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

  
Hi. I have connected my SSAS in SQL server 2008 to an Oracle database.  I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube.  Now everything was going fine.  I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But.  When I come to process the Cube it throws these errors.  Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.

Create List Sharepoint Client Object Model Access Denied

  

Hi,

I am trying to create a silverlight application by making use of the SharePoint 2010 Client Object Model using the following code:

private void CreateList(object sender, ClientRequestFailedEventArgs e)
{
  ClientContext ctx = new ClientContext("http://server");
  ListCreationInformation lc = new ListCreationInformation();
  lc.Title = "FlexiTime";
  lc.Description = "";
  lc.TemplateType = (int)ListTemplateType.GenericList;
  List newList = ctx.Web.Lists.Add(lc);
  System.Threading.ThreadPool.QueueUserWorkItem(new WaitCallback(CreateListCallback), ctx);
}

private void CreateListCallback(object s)
{
  var context = (ClientContext)s;  
  context.ExecuteQuery();
  this.Dispatcher.BeginInvoke(GetList);
}

The error I receive is as follows:

{System.Security.Se

Exception when access to sharepoint by Client Object Model

  

Hello ,

  - I have a windows Application .

  - In the  Form  load , I write the following code to aceess sharepoint site :

      ClientContext clientContext = new ClientContext("URL");

     Web site = clientContext.Web;

    clientContext.Load(site);

    clientContext.ExecuteQuery();

    MessageBox.Show("Title: {0}", site.Title);

  The following exception happened when execute query :

         "The re

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

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

How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?

  

I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.

Thanks,

____


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

Sharepoint Attachment and access web database

  

In a sharepoint 2010 site, I create with access (2010) a web database, I have attached a document (pdf) to a table, but i am not able to see it .

I thought that if i open the site i could be able to opent It, but it does show only no attachment (if it is empty) otherwise if there is an attachment the field is blank.

How can i be able to open the attachment ???

Thanks for your help


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.


ManagedProperty requires access to SharePoint database to set FullTextQueryable property

  

I have the following method below to set the FullTextQueryable property on a ManagedProperty

  public class Search
  {
    /// <summary>
    /// Set a managed property to be both queriable and retrievable.
    /// </summary>
    /// <param name="managedProperty">The name of the property</param>
    /// <param name="makeFullTextQueriable"></param>
    public static void SetManagedPropertyFullTextQueriable(string managedProperty, bool makeFullTextQueriable)
    {

 

      SearchService searchService = SearchService.Service;

      SearchServiceApplication searchApp = searchService.SearchApplications.GetValue<SearchServiceApplication>(
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