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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Access, InfoPath, Outlook & SharePoint Integration

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

I work for a major banking institution, in a group whose remit it to provide account ownership information for ~300k accounts worldwide.  In this instance “account ownership” is defined as the bank employee who is responsible for verifying and attesting to monthly transactions and balances in each individual account.  Each account owner can have one or many individual accounts.

I have developed an MS Access database to house the account information, and have developed an MS InfoPath form to collect data from the account owner.  Currently, I have a direct connection between the database and the form but would like to migrate to MS SharePoint site because of the limitations (both user and security) of MS Access.

Ideally, on a monthly basis, I would like to:

1.) &n

View Complete Post

More Related Resource Links

Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround? Many thanks to anyone who can help!

access outlook in sharepoint

Can we edit delete and send emails through sharepoint like in outlook?

Email InfoPath form located on secure SharePoint 2007 using Outlook


I have a 2007 InfoPath form that is stored on a secure 2007 SharePoint team site that needs to be emailed to outside users for feedback on a certain subject. The form is opened by a team member (with site access), sent to the reviewer to provide feedback (via Outlook 2007), and then submitted back to the team member for review and submission to the SharePoint site.

The issue I've encountered is that the outside user who receives the form in Outlook as the body of the email cannot enter information in any fields in order to provide feedback. The option to "include the form template with the email" is blocked in my InfoPath form options (I believe because the form location is a secured site). I have tried adding the users to permissions in just the library where the form is published to, but they still cannot enter any information.

Can someone provide me with a solution for this problem?

Improvements with Sharepoint and Outlook calendar integration?

The "Connect to Outlook" feature is a great feature to synchronize Outlook 2007 and Sharepoint 2007. It allows showing events created from Sharepoint calendars in Outlook. But for me, there are some limitations that really blocked some users of using Sharepoint calendar:

- even if users can detect manually conflicts in outlook between sharepoint events and their own events of their own Outlook calendar, there is no automatic alert.
- when creating events from Sharepoint, users cannot invit attendees
- if users have already created an event into their own outlook calendar, their is no way to publish it to Sharepoint

Actually I would like to know if Sharepoint 2010 and Outlook 2010 will improve these points.

Thank you.

Sharepoint Access DB Infopath form


Is it possible to store the access database inside sharepoint with infopath as front end form.

My findings is; we have access database inside sharepoint but unable to desing infopath form for this.

Infopath 2010 and Microsoft Access integration issues



I followed all the steps in the help article to create a new form from an existing Microsoft Access database. I publish this form using the "publish to network folder option" but i use a local folder on my computer

The form opens and i can add data, but when i submit it, i get this error mesage: Accessing data across domains is not supported for forms opened from the Internet

The database is located in the same folder as the published form so i am not sure what i am doing wrong here.Any help would be appreciated




Infopath form in SharePoint export to SQL or Access


I have an infopath form on a sharepoint site.  Whenever users hit submit button data goes and sits in a table in sharepoint.  Instead I need to export all that information to a SQL table.

Anyone knows what is the procedure to do that?


Sharepoint Helpdesk & Outlook Integration

Is there a way to set up the Helpdesk in Sharepoint so that when an email is sent to an email group of say IT Request, the email would automatically create a service request?

Outlook.Application in Infopath 2003/SharePoint 2010


I transferred our form library from SP2003 to SP2010. Everything works except for when I try to submit the form via Outlook using "Outlook.Application". 

var objOutlook = new ActiveXObject( "Outlook.Application" );
var olMailItem;
var objOutlookMsg = objOutlook.CreateItem(olMailItem);

We are still using Office 2003 with SharePoint 2010. Anyone know if the above code doesnt work anymore in SP2010?

Thank you,


InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

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

Outlook 2010 / Sharepoint authenthication issue


Hi all,

I'm using Outlook 2010 on Windows 7 64bit.

My company uses a hosted Sharepoint server (I guess it's Sharepoint 2010). There's a team calendar, which I would like to connect to my Outlook 2010. Linking it to Outlook works fine until it tries to update the calendar with the Sharepoint server. I shows the following error:

Error (0x80070005) when running the task "SharePoint": "You are not authorized to view the SharePoint list (team calendar). Contact the administrator of SharePoint site. HTTP 401."

So this tells me, I'm not authorized to connect - which is quite clear because Outlook never asked my for any username or password.

Funny thing is when I try to add an internet calendar (Right mouse click on calendars, Add calendar, Internet calendar) and use the url of the sharepoint list, it asks me for username and password, but then fails to add the calendar, as it isn't a webcal (which is OK).

BUT: As Outlook at this moment has the username and password, the exisiting Sharepoint calendar synchronizes correctly. This works until Outlook is being restarted.

Does anyone have an idea why I'm not asked for any authentication? Maybe there's some setting I haven't found yet? It works with trying to add the webcal any time when I start Outlook, but t

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


Immanuel c


sharepoint access dissabled automatically in every twodays

The problem seems to be that our administrators grant access to specific portals / folders and then without warning or any actions from our part the next week access is disabled

Sharepoint access dissabled automatically in every two days

The problem seems to be that our administrators grant access to specific portals / folders and then without warning or any actions from our part the next week access is disabled

Insert image into Infopath form and save to SharePoint as PDF file


I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.

Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser.  However, now I need to go one step further with this scenario:

1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form.  Also, what are the security requirements for storing such images, but not granting all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?

2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).

Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).


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