Newbie Questions

Re: data connection

Dafydd — Thu, 12 Jan 2012 12:40:17 GMT

Hi the conncetion im trying to remove is 01

daf

<?xml version="1.0" encoding="UTF-8"?>

<xsf:xDocumentClass solutionFormatVersion="2.0.0.0" dataFormSolution="yes" solutionVersion="1.0.0.105" productVersion="12.0.0" publishUrl="C:\Documents and Settings\drrpl\Desktop\New Folder\manifest.xsf" name="urn:schemas-microsoft-com:office:infopath:Forms:-dataFormSolution" xmlns:xsf="http://schemas.microsoft.com/office/infopath/2003/solutionDefinition" xmlns:xsf2="http://schemas.microsoft.com/office/infopath/2006/solutionDefinition/extensions" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xdUtil="http://schemas.microsoft.com/office/infopath/2003/xslt/Util" xmlns:xdXDocument="http://schemas.microsoft.com/office/infopath/2003/xslt/xDocument" xmlns:xdMath="http://schemas.microsoft.com/office/infopath/2003/xslt/Math" xmlns:xdDate="http://schemas.microsoft.com/office/infopath/2003/xslt/Date" xmlns:xdExtension="http://schemas.microsoft.com/office/infopath/2003/xslt/extension" xmlns:xdEnvironment="http://schemas.microsoft.com/office/infopath/2006/xslt/environment" xmlns:xdUser="http://schemas.microsoft.com/office/infopath/2006/xslt/User" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17" xmlns:xdado="http://schemas.microsoft.com/office/infopath/2003/adomapping">
<xsf:package>
  <xsf:files>
   <xsf:file name="schema.xsd">
    <xsf:fileProperties>
     <xsf:property name="editability" type="string" value="none"></xsf:property>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>
     <xsf:property name="rootElement" type="string" value="myFields"></xsf:property>
     <xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="schema1.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"></xsf:property>
     <xsf:property name="editability" type="string" value="none"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="schema2.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"></xsf:property>
     <xsf:property name="editability" type="string" value="none"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="template.xml"></xsf:file>
   <xsf:file name="sampledata.xml">
    <xsf:fileProperties>
     <xsf:property name="fileType" type="string" value="sampleData"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="view1.xsl">
    <xsf:fileProperties>
     <xsf:property name="lang" type="string" value="1033"></xsf:property>
     <xsf:property name="queryView" type="string" value="yes"></xsf:property>
     <xsf:property name="componentId" type="string" value="42"></xsf:property>
     <xsf:property name="xmlToEditName" type="string" value="51"></xsf:property>
     <xsf:property name="mode" type="string" value="3"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="Master_offline.xml"></xsf:file>
   <xsf:file name="426A8018.png">
    <xsf:fileProperties>
     <xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="View2.xsl">
    <xsf:fileProperties>
     <xsf:property name="lang" type="string" value="1033"></xsf:property>
     <xsf:property name="componentId" type="string" value="57"></xsf:property>
     <xsf:property name="xmlToEditName" type="string" value="83"></xsf:property>
     <xsf:property name="mode" type="string" value="2"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="D229F2CA.png">
    <xsf:fileProperties>
     <xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="24766FED.png">
    <xsf:fileProperties>
     <xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="myschema.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17"></xsf:property>
     <xsf:property name="editability" type="string" value="full"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="2CD2CBE8.jpg">
    <xsf:fileProperties>
     <xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="Master2.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>
     <xsf:property name="dataObject" type="string" value="Master"></xsf:property>
     <xsf:property name="rootElement" type="string" value="myFields"></xsf:property>
     <xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="Master3.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"></xsf:property>
     <xsf:property name="dataObject" type="string" value="Master"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
   <xsf:file name="Master 2.xsd">
    <xsf:fileProperties>
     <xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>
     <xsf:property name="dataObject" type="string" value="Master 2"></xsf:property>
     <xsf:property name="rootElement" type="string" value="myFields"></xsf:property>
     <xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>
  </xsf:files>
</xsf:package>
<xsf:importParameters enabled="yes" useScriptHandler="no"></xsf:importParameters>
<xsf:extensions>
  <xsf:extension name="SolutionDefinitionExtensions">
   <xsf2:solutionDefinition runtimeCompatibility="client" allowClientOnlyCode="no" verifyOnServer="yes">
    <xsf2:offline openIfQueryFails="yes" cacheQueries="yes"></xsf2:offline>
    <xsf2:dataConnections>
     <xsf2:adoAdapterExtension ref="01" submitAdapterName="Main connection submit"></xsf2:adoAdapterExtension>
     <xsf2:adoAdapterExtension ref="Master" queryKey="Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\drrpl\Desktop\Directory Type\Mon_Menai_01.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=Falseselect [ID],[Funded By] as [Funded_By],[Provision ] as [Provision_],[Target Group] as [Target_Group],[Description of Provision] as [Description_of_Provision],[Delivered By] as [Delivered_By],[How to Access] as [How_to_Access],[Contact Name] as [Contact_Name],[Contact Number] as [Contact_Number],[Contact email] as [Contact_email],[Website],[Geographical area] as [Geographical_area],[Type],[Start Date] as [Start_Date],[End Date] as [End_Date] from [Master] as [Master]Master" queryFile="Master_offline.xml"></xsf2:adoAdapterExtension>
    </xsf2:dataConnections>
    <xsf2:viewsExtension>
     <xsf2:viewExtension ref="View 1" designMode="normal" clientOnly="no"></xsf2:viewExtension>
     <xsf2:viewExtension ref="View 2" designMode="normal" clientOnly="no"></xsf2:viewExtension>
    </xsf2:viewsExtension>
    <xsf2:server isPreSubmitPostBackEnabled="no" isMobileEnabled="no" formLocale="en-GB">
     <xsf2:toolbar enabledTop="yes" enabledBottom="yes">
      <xsf2:commands>
       <xsf2:command action="submit"></xsf2:command>
       <xsf2:command action="save"></xsf2:command>
       <xsf2:command action="saveAs"></xsf2:command>
       <xsf2:command action="close"></xsf2:command>
       <xsf2:command action="view"></xsf2:command>
       <xsf2:command action="print"></xsf2:command>
      </xsf2:commands>
     </xsf2:toolbar>
    </xsf2:server>
    <xsf2:solutionPropertiesExtension branch="wss">
     <xsf2:contentTypeTemplate site="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/" path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Shared Documents/Forms.xsn" name="Infopath test" description="infoPath Form" browserEnable="no"></xsf2:contentTypeTemplate>
     <xsf2:wss path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/InfoPath" name="Infopath" description="" browserEnable="no"></xsf2:wss>
     <xsf2:share formName="Online Directory" path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Croeso/Online%20Directory%20.xsn" accessPath="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Croeso/Online%20Directory%20.xsn"></xsf2:share>
    </xsf2:solutionPropertiesExtension>
   </xsf2:solutionDefinition>
  </xsf:extension>
</xsf:extensions>
<xsf:views default="View 1">
  <xsf:view name="View 1" caption="View 1" showMenuItem="yes" designMode="protected">
   <xsf:editing>
    <xsf:xmlToEdit name="Target_Group_44" item="/dfs:myFields/dfs:dataFields/d:Master/@Target_Group">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="How_to_Access_48" item="/dfs:myFields/dfs:dataFields/d:Master/@How_to_Access">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="ID_42" item="/dfs:myFields/dfs:dataFields/d:Master/@ID">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Provision__43" item="/dfs:myFields/dfs:dataFields/d:Master/@Provision_">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Funded_By_45" item="/dfs:myFields/dfs:dataFields/d:Master/@Funded_By">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Description_of_Provision_46" item="/dfs:myFields/dfs:dataFields/d:Master/@Description_of_Provision">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Delivered_By_47" item="/dfs:myFields/dfs:dataFields/d:Master/@Delivered_By">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Master_49" item="/dfs:myFields/dfs:dataFields/d:Master" container="/dfs:myFields">
     <xsf:editWith caption="Master" xd:autogeneration="template" component="xCollection">
      <xsf:fragmentToInsert>
       <xsf:chooseFragment parent="dfs:dataFields" innerFragment="d:Master">
        <d:Master ID="" Funded_By="" Provision_="" Target_Group="" Description_of_Provision="" Delivered_By="" How_to_Access="" Contact_Name="" Contact_Number="" Contact_email="" Website="" Geographical_area="" Type="" Start_Date="" End_Date=""></d:Master>
       </xsf:chooseFragment>
      </xsf:fragmentToInsert>
     </xsf:editWith>
    </xsf:xmlToEdit>
   </xsf:editing>
   <xsf:mainpane transform="view1.xsl"></xsf:mainpane>
   <xsf:unboundControls>
    <xsf:button name="CTRL39_7">
     <xsf:ruleSetAction ruleSet="ruleSet_1"></xsf:ruleSetAction>
    </xsf:button>
   </xsf:unboundControls>
   <xsf:menuArea name="msoInsertMenu">
    <xsf:menu caption="&Section">
     <xsf:button action="xCollection::insert" xmlToEdit="Master_49" caption="Master"></xsf:button>
    </xsf:menu>
   </xsf:menuArea>
   <xsf:menuArea name="msoStructuralEditingContextMenu">
    <xsf:button action="xCollection::insertBefore" xmlToEdit="Master_49" caption="Insert Master before" showIf="immediate"></xsf:button>
    <xsf:button action="xCollection::insertAfter" xmlToEdit="Master_49" caption="Insert Master after" showIf="immediate"></xsf:button>
    <xsf:button action="xCollection::remove" xmlToEdit="Master_49" caption="Remove Master" showIf="immediate"></xsf:button>
    <xsf:button action="xCollection::insert" xmlToEdit="Master_49" caption="Insert Master" showIf="immediate"></xsf:button>
   </xsf:menuArea>
  </xsf:view>
  <xsf:view showMenuItem="yes" name="View 2" caption="View 2" designMode="protected">
   <xsf:editing>
    <xsf:xmlToEdit name="Funded_By_66" item="/dfs:myFields/dfs:dataFields/d:Master/@Funded_By">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Description_of_Provision_67" item="/dfs:myFields/dfs:dataFields/d:Master/@Description_of_Provision">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Geographical_area_73" item="/dfs:myFields/dfs:dataFields/d:Master/@Geographical_area">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Delivered_By_68" item="/dfs:myFields/dfs:dataFields/d:Master/@Delivered_By">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Target_Group_65" item="/dfs:myFields/dfs:dataFields/d:Master/@Target_Group">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Contact_email_70" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_email">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="How_to_Access_69" item="/dfs:myFields/dfs:dataFields/d:Master/@How_to_Access">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="ID_63" item="/dfs:myFields/dfs:dataFields/d:Master/@ID">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Contact_Name_74" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_Name">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Provision__64" item="/dfs:myFields/dfs:dataFields/d:Master/@Provision_">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Website_71" item="/dfs:myFields/dfs:dataFields/d:Master/@Website">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Contact_Number_72" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_Number">
     <xsf:editWith component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="End_Date_83" item="/dfs:myFields/dfs:dataFields/d:Master/@End_Date">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
    <xsf:xmlToEdit name="Start_Date_82" item="/dfs:myFields/dfs:dataFields/d:Master/@Start_Date">
     <xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>
    </xsf:xmlToEdit>
   </xsf:editing>
   <xsf:mainpane transform="View2.xsl"></xsf:mainpane>
   <xsf:unboundControls>
    <xsf:button name="CTRL15_13">
     <xsf:ruleSetAction ruleSet="ruleSet_2"></xsf:ruleSetAction>
    </xsf:button>
    <xsf:button name="CTRL3_7">
     <xsf:ruleSetAction ruleSet="ruleSet_3"></xsf:ruleSetAction>
    </xsf:button>
    <xsf:button name="CTRL6_7">
     <xsf:ruleSetAction ruleSet="ruleSet_4"></xsf:ruleSetAction>
    </xsf:button>
    <xsf:button name="CTRL4_7">
     <xsf:ruleSetAction ruleSet="ruleSet_5"></xsf:ruleSetAction>
    </xsf:button>
    <xsf:button name="CTRL5_7">
     <xsf:ruleSetAction ruleSet="ruleSet_6"></xsf:ruleSetAction>
    </xsf:button>
   </xsf:unboundControls>
  </xsf:view>
</xsf:views>
<xsf:applicationParameters application="InfoPath Design Mode">
  <xsf:solutionProperties fullyEditableNamespace="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17" lastOpenView="view1.xsl" lastVersionNeedingTransform="1.0.0.100"></xsf:solutionProperties>
</xsf:applicationParameters>
<xsf:documentSchemas>
  <xsf:documentSchema rootSchema="yes" location="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution schema.xsd"></xsf:documentSchema>
  <xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields schema1.xsd"></xsf:documentSchema>
  <xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields schema2.xsd"></xsf:documentSchema>
  <xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17 myschema.xsd"></xsf:documentSchema>
</xsf:documentSchemas>
<xsf:fileNew>
  <xsf:initialXmlDocument caption="Forms" href="template.xml"></xsf:initialXmlDocument>
</xsf:fileNew>
<xsf:dataObjects>
  <xsf:dataObject name="Master" schema="Master2.xsd" initOnLoad="yes">
   <xsf:query>
    <xsf:adoAdapter connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\drrpl\Desktop\Directory Type\Mon_Menai_01.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False" commandText="select [ID],[Funded By] as [Funded_By],[Provision ] as [Provision_],[Target Group] as [Target_Group],[Description of Provision] as [Description_of_Provision],[Delivered By] as [Delivered_By],[How to Access] as [How_to_Access],[Contact Name] as [Contact_Name],[Contact Number] as [Contact_Number],[Contact email] as [Contact_email],[Website],[Geographical area] as [Geographical_area],[Type],[Start Date] as [Start_Date],[End Date] as [End_Date] from [Master] as [Master]" queryAllowed="yes" name="Master"></xsf:adoAdapter>
   </xsf:query>
  </xsf:dataObject>
  <xsf:dataObject name="Master 2" schema="Master 2.xsd" initOnLoad="yes">
   <xsf:query>
    <xsf:sharepointListAdapter siteUrl="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/" sharepointGuid="{51347A40-9A5A-4169-A4A0-1BACD4AAA095}" infopathGroup="Master" queryAllowed="yes" submitAllowed="no" name="Master 2">
     <xsf:field sharepointName="Title" infopathName="Funded_By"></xsf:field>
     <xsf:field sharepointName="Provision_x0020_" infopathName="Provision_"></xsf:field>
     <xsf:field sharepointName="Target_x0020_Group" infopathName="Target_Group"></xsf:field>
     <xsf:field sharepointName="Description_x0020_of_x0020_Provi" infopathName="Description_of_Provision"></xsf:field>
     <xsf:field sharepointName="Delivered_x0020_By" infopathName="Delivered_By"></xsf:field>
     <xsf:field sharepointName="How_x0020_to_x0020_Access" infopathName="How_to_Access"></xsf:field>
     <xsf:field sharepointName="Contact_x0020_Name" infopathName="Contact_Name"></xsf:field>
     <xsf:field sharepointName="Contact_x0020_Number" infopathName="Contact_Number"></xsf:field>
     <xsf:field sharepointName="Contact_x0020_email" infopathName="Contact_email"></xsf:field>
     <xsf:field sharepointName="Website" infopathName="Website"></xsf:field>
     <xsf:field sharepointName="Geographical_x0020_area" infopathName="Geographical_area"></xsf:field>
     <xsf:field sharepointName="Type" infopathName="Type"></xsf:field>
     <xsf:field sharepointName="Start_x0020_Date" infopathName="Start_Date"></xsf:field>
     <xsf:field sharepointName="End_x0020_Date" infopathName="End_Date"></xsf:field>
     <xsf:field sharepointName="ID" infopathName="ID"></xsf:field>
    </xsf:sharepointListAdapter>
   </xsf:query>
  </xsf:dataObject>
</xsf:dataObjects>
<xsf:ruleSets>
  <xsf:ruleSet name="ruleSet_1">
   <xsf:rule caption="Switch to View 2" isEnabled="yes">
    <xsf:switchViewAction view="View 2"></xsf:switchViewAction>
   </xsf:rule>
  </xsf:ruleSet>
  <xsf:ruleSet name="ruleSet_2">
   <xsf:rule caption="Switch to View 1" isEnabled="yes">
    <xsf:switchViewAction view="View 1"></xsf:switchViewAction>
   </xsf:rule>
  </xsf:ruleSet>
  <xsf:ruleSet name="ruleSet_3">
   <xsf:rule caption="Rule 1" isEnabled="yes">
    <xsf:assignmentAction targetField="my:CurrentRecordNumber" expression=""1""></xsf:assignmentAction>
   </xsf:rule>
  </xsf:ruleSet>
  <xsf:ruleSet name="ruleSet_4">
   <xsf:rule caption="Rule 1" isEnabled="yes">
    <xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="count(dfs:dataFields/d:Master)"></xsf:assignmentAction>
   </xsf:rule>
  </xsf:ruleSet>
  <xsf:ruleSet name="ruleSet_5">
   <xsf:rule caption="Rule 1" condition="my:CurrentRecordNumber > 1" isEnabled="yes">
    <xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="xdMath:Nz(my:CurrentRecordNumber) - 1"></xsf:assignmentAction>
   </xsf:rule>
  </xsf:ruleSet>
  <xsf:ruleSet name="ruleSet_6">
   <xsf:rule caption="Rule 1" condition="my:CurrentRecordNumber < count(dfs:dataFields/d:Master)" isEnabled="yes">
    <xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="xdMath:Nz(my:CurrentRecordNumber) + 1"></xsf:assignmentAction>
   </xsf:rule>
  </xsf:ruleSet>
</xsf:ruleSets>
<xsf:query>
  <xsf:adoAdapter connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\drrpl\Desktop\Directory Type\Mon_Menai_01.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False" commandText="select [ID],[Funded By] as [Funded_By],[Provision ] as [Provision_],[Target Group] as [Target_Group],[Description of Provision] as [Description_of_Provision],[Delivered By] as [Delivered_By],[How to Access] as [How_to_Access],[Contact Name] as [Contact_Name],[Contact Number] as [Contact_Number],[Contact email] as [Contact_email],[Website],[Geographical area] as [Geographical_area],[Type],[Start Date] as [Start_Date],[End Date] as [End_Date] from [Master] as [Master]" queryAllowed="yes" name="01" submitAllowed="yes"></xsf:adoAdapter>
</xsf:query>
<xsf:submit caption="Su&bmit">
  <xsf:useQueryAdapter></xsf:useQueryAdapter>
</xsf:submit>
</xsf:xDocumentClass>

Re: data connection

Dafydd — Thu, 12 Jan 2012 11:19:22 GMT

Hi here is the manifest.xsf file could you please find the database connection named 01 and delete the required code ?

thanks

daf

<?xml version="1.0" encoding="UTF-8"?>

<!--

This file is automatically created and modified by Microsoft Office InfoPath.

Changes made to the file outside of InfoPath might be lost if the form template is modified in InfoPath.

-->

<xsf:xDocumentClass solutionFormatVersion="2.0.0.0" dataFormSolution="yes" solutionVersion="1.0.0.105" productVersion="12.0.0" publishUrl="C:\Documents and Settings\drrpl\Desktop\New Folder\manifest.xsf" name="urn:schemas-microsoft-com:office:infopath:Forms:-dataFormSolution" xmlns:xsf="http://schemas.microsoft.com/office/infopath/2003/solutionDefinition" xmlns:xsf2="http://schemas.microsoft.com/office/infopath/2006/solutionDefinition/extensions" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xdUtil="http://schemas.microsoft.com/office/infopath/2003/xslt/Util" xmlns:xdXDocument="http://schemas.microsoft.com/office/infopath/2003/xslt/xDocument" xmlns:xdMath="http://schemas.microsoft.com/office/infopath/2003/xslt/Math" xmlns:xdDate="http://schemas.microsoft.com/office/infopath/2003/xslt/Date" xmlns:xdExtension="http://schemas.microsoft.com/office/infopath/2003/xslt/extension" xmlns:xdEnvironment="http://schemas.microsoft.com/office/infopath/2006/xslt/environment" xmlns:xdUser="http://schemas.microsoft.com/office/infopath/2006/xslt/User" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17" xmlns:xdado="http://schemas.microsoft.com/office/infopath/2003/adomapping">

<xsf:package>

<xsf:files>

<xsf:file name="schema.xsd">

<xsf:fileProperties>

<xsf:property name="editability" type="string" value="none"></xsf:property>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>

<xsf:property name="rootElement" type="string" value="myFields"></xsf:property>

<xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="schema1.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"></xsf:property>

<xsf:property name="editability" type="string" value="none"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="schema2.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"></xsf:property>

<xsf:property name="editability" type="string" value="none"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="template.xml"></xsf:file>

<xsf:file name="sampledata.xml">

<xsf:fileProperties>

<xsf:property name="fileType" type="string" value="sampleData"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="view1.xsl">

<xsf:fileProperties>

<xsf:property name="lang" type="string" value="1033"></xsf:property>

<xsf:property name="queryView" type="string" value="yes"></xsf:property>

<xsf:property name="componentId" type="string" value="42"></xsf:property>

<xsf:property name="xmlToEditName" type="string" value="51"></xsf:property>

<xsf:property name="mode" type="string" value="3"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="Master_offline.xml"></xsf:file>

<xsf:file name="426A8018.png">

<xsf:fileProperties>

<xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="View2.xsl">

<xsf:fileProperties>

<xsf:property name="lang" type="string" value="1033"></xsf:property>

<xsf:property name="componentId" type="string" value="57"></xsf:property>

<xsf:property name="xmlToEditName" type="string" value="83"></xsf:property>

<xsf:property name="mode" type="string" value="2"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="D229F2CA.png">

<xsf:fileProperties>

<xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="24766FED.png">

<xsf:fileProperties>

<xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="myschema.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17"></xsf:property>

<xsf:property name="editability" type="string" value="full"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="2CD2CBE8.jpg">

<xsf:fileProperties>

<xsf:property name="fileType" type="string" value="viewComponent"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="Master2.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>

<xsf:property name="dataObject" type="string" value="Master"></xsf:property>

<xsf:property name="rootElement" type="string" value="myFields"></xsf:property>

<xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="Master3.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"></xsf:property>

<xsf:property name="dataObject" type="string" value="Master"></xsf:property>

</xsf:fileProperties>

</xsf:file>

<xsf:file name="Master 2.xsd">

<xsf:fileProperties>

<xsf:property name="namespace" type="string" value="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"></xsf:property>

<xsf:property name="dataObject" type="string" value="Master 2"></xsf:property>

<xsf:property name="rootElement" type="string" value="myFields"></xsf:property>

<xsf:property name="useOnDemandAlgorithm" type="string" value="yes"></xsf:property>

</xsf:fileProperties>

</xsf:file>

</xsf:files>

</xsf:package>

<xsf:importParameters enabled="yes" useScriptHandler="no"></xsf:importParameters>

<xsf:extensions>

<xsf:extension name="SolutionDefinitionExtensions">

<xsf2:solutionDefinition runtimeCompatibility="client" allowClientOnlyCode="no" verifyOnServer="yes">

<xsf2:offline openIfQueryFails="yes" cacheQueries="yes"></xsf2:offline>

<xsf2:dataConnections>

<xsf2:adoAdapterExtension ref="01" submitAdapterName="Main connection submit"></xsf2:adoAdapterExtension>

<xsf2:adoAdapterExtension ref="Master" queryKey="Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\drrpl\Desktop\Directory Type\Mon_Menai_01.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=Falseselect [ID],[Funded By] as [Funded_By],[Provision ] as [Provision_],[Target Group] as [Target_Group],[Description of Provision] as [Description_of_Provision],[Delivered By] as [Delivered_By],[How to Access] as [How_to_Access],[Contact Name] as [Contact_Name],[Contact Number] as [Contact_Number],[Contact email] as [Contact_email],[Website],[Geographical area] as [Geographical_area],[Type],[Start Date] as [Start_Date],[End Date] as [End_Date] from [Master] as [Master]Master" queryFile="Master_offline.xml"></xsf2:adoAdapterExtension>

</xsf2:dataConnections>

<xsf2:viewsExtension>

<xsf2:viewExtension ref="View 1" designMode="normal" clientOnly="no"></xsf2:viewExtension>

<xsf2:viewExtension ref="View 2" designMode="normal" clientOnly="no"></xsf2:viewExtension>

</xsf2:viewsExtension>

<xsf2:server isPreSubmitPostBackEnabled="no" isMobileEnabled="no" formLocale="en-GB">

<xsf2:toolbar enabledTop="yes" enabledBottom="yes">

<xsf2:commands>

<xsf2:command action="submit"></xsf2:command>

<xsf2:command action="save"></xsf2:command>

<xsf2:command action="saveAs"></xsf2:command>

<xsf2:command action="close"></xsf2:command>

<xsf2:command action="view"></xsf2:command>

<xsf2:command action="print"></xsf2:command>

</xsf2:commands>

</xsf2:toolbar>

</xsf2:server>

<xsf2:solutionPropertiesExtension branch="wss">

<xsf2:contentTypeTemplate site="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/" path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Shared Documents/Forms.xsn" name="Infopath test" description="infoPath Form" browserEnable="no"></xsf2:contentTypeTemplate>

<xsf2:wss path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/InfoPath" name="Infopath" description="" browserEnable="no"></xsf2:wss>

<xsf2:share formName="Online Directory" path="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Croeso/Online%20Directory%20.xsn" accessPath="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/Croeso/Online%20Directory%20.xsn"></xsf2:share>

</xsf2:solutionPropertiesExtension>

</xsf2:solutionDefinition>

</xsf:extension>

</xsf:extensions>

<xsf:views default="View 1">

<xsf:view name="View 1" caption="View 1" showMenuItem="yes" designMode="protected">

<xsf:editing>

<xsf:xmlToEdit name="Target_Group_44" item="/dfs:myFields/dfs:dataFields/d:Master/@Target_Group">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="How_to_Access_48" item="/dfs:myFields/dfs:dataFields/d:Master/@How_to_Access">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="ID_42" item="/dfs:myFields/dfs:dataFields/d:Master/@ID">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Provision__43" item="/dfs:myFields/dfs:dataFields/d:Master/@Provision_">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Funded_By_45" item="/dfs:myFields/dfs:dataFields/d:Master/@Funded_By">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Description_of_Provision_46" item="/dfs:myFields/dfs:dataFields/d:Master/@Description_of_Provision">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Delivered_By_47" item="/dfs:myFields/dfs:dataFields/d:Master/@Delivered_By">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Master_49" item="/dfs:myFields/dfs:dataFields/d:Master" container="/dfs:myFields">

<xsf:editWith caption="Master" xd:autogeneration="template" component="xCollection">

<xsf:fragmentToInsert>

<xsf:chooseFragment parent="dfs:dataFields" innerFragment="d:Master">

<d:Master ID="" Funded_By="" Provision_="" Target_Group="" Description_of_Provision="" Delivered_By="" How_to_Access="" Contact_Name="" Contact_Number="" Contact_email="" Website="" Geographical_area="" Type="" Start_Date="" End_Date=""></d:Master>

</xsf:chooseFragment>

</xsf:fragmentToInsert>

</xsf:editWith>

</xsf:xmlToEdit>

</xsf:editing>

<xsf:mainpane transform="view1.xsl"></xsf:mainpane>

<xsf:unboundControls>

<xsf:button name="CTRL39_7">

<xsf:ruleSetAction ruleSet="ruleSet_1"></xsf:ruleSetAction>

</xsf:button>

</xsf:unboundControls>

<xsf:menuArea name="msoInsertMenu">

<xsf:menu caption="&Section">

<xsf:button action="xCollection::insert" xmlToEdit="Master_49" caption="Master"></xsf:button>

</xsf:menu>

</xsf:menuArea>

<xsf:menuArea name="msoStructuralEditingContextMenu">

<xsf:button action="xCollection::insertBefore" xmlToEdit="Master_49" caption="Insert Master before" showIf="immediate"></xsf:button>

<xsf:button action="xCollection::insertAfter" xmlToEdit="Master_49" caption="Insert Master after" showIf="immediate"></xsf:button>

<xsf:button action="xCollection::remove" xmlToEdit="Master_49" caption="Remove Master" showIf="immediate"></xsf:button>

<xsf:button action="xCollection::insert" xmlToEdit="Master_49" caption="Insert Master" showIf="immediate"></xsf:button>

</xsf:menuArea>

</xsf:view>

<xsf:view showMenuItem="yes" name="View 2" caption="View 2" designMode="protected">

<xsf:editing>

<xsf:xmlToEdit name="Funded_By_66" item="/dfs:myFields/dfs:dataFields/d:Master/@Funded_By">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Description_of_Provision_67" item="/dfs:myFields/dfs:dataFields/d:Master/@Description_of_Provision">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Geographical_area_73" item="/dfs:myFields/dfs:dataFields/d:Master/@Geographical_area">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Delivered_By_68" item="/dfs:myFields/dfs:dataFields/d:Master/@Delivered_By">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Target_Group_65" item="/dfs:myFields/dfs:dataFields/d:Master/@Target_Group">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Contact_email_70" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_email">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="How_to_Access_69" item="/dfs:myFields/dfs:dataFields/d:Master/@How_to_Access">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="ID_63" item="/dfs:myFields/dfs:dataFields/d:Master/@ID">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Contact_Name_74" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_Name">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Provision__64" item="/dfs:myFields/dfs:dataFields/d:Master/@Provision_">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Website_71" item="/dfs:myFields/dfs:dataFields/d:Master/@Website">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Contact_Number_72" item="/dfs:myFields/dfs:dataFields/d:Master/@Contact_Number">

<xsf:editWith component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="End_Date_83" item="/dfs:myFields/dfs:dataFields/d:Master/@End_Date">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

<xsf:xmlToEdit name="Start_Date_82" item="/dfs:myFields/dfs:dataFields/d:Master/@Start_Date">

<xsf:editWith proofing="no" autoComplete="no" component="xField"></xsf:editWith>

</xsf:xmlToEdit>

</xsf:editing>

<xsf:mainpane transform="View2.xsl"></xsf:mainpane>

<xsf:unboundControls>

<xsf:button name="CTRL15_13">

<xsf:ruleSetAction ruleSet="ruleSet_2"></xsf:ruleSetAction>

</xsf:button>

<xsf:button name="CTRL3_7">

<xsf:ruleSetAction ruleSet="ruleSet_3"></xsf:ruleSetAction>

</xsf:button>

<xsf:button name="CTRL6_7">

<xsf:ruleSetAction ruleSet="ruleSet_4"></xsf:ruleSetAction>

</xsf:button>

<xsf:button name="CTRL4_7">

<xsf:ruleSetAction ruleSet="ruleSet_5"></xsf:ruleSetAction>

</xsf:button>

<xsf:button name="CTRL5_7">

<xsf:ruleSetAction ruleSet="ruleSet_6"></xsf:ruleSetAction>

</xsf:button>

</xsf:unboundControls>

</xsf:view>

</xsf:views>

<xsf:applicationParameters application="InfoPath Design Mode">

<xsf:solutionProperties fullyEditableNamespace="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17" lastOpenView="view1.xsl" lastVersionNeedingTransform="1.0.0.100"></xsf:solutionProperties>

</xsf:applicationParameters>

<xsf:documentSchemas>

<xsf:documentSchema rootSchema="yes" location="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution schema.xsd"></xsf:documentSchema>

<xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields schema1.xsd"></xsf:documentSchema>

<xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields schema2.xsd"></xsf:documentSchema>

<xsf:documentSchema location="http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-11-28T11:34:17 myschema.xsd"></xsf:documentSchema>

</xsf:documentSchemas>

<xsf:fileNew>

<xsf:initialXmlDocument caption="Forms" href="template.xml"></xsf:initialXmlDocument>

</xsf:fileNew>

<xsf:dataObjects>

<xsf:dataObject name="Master" schema="Master2.xsd" initOnLoad="yes">

<xsf:query>

<xsf:adoAdapter connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\drrpl\Desktop\Directory Type\Mon_Menai_01.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False" commandText="select [ID],[Funded By] as [Funded_By],[Provision ] as [Provision_],[Target Group] as [Target_Group],[Description of Provision] as [Description_of_Provision],[Delivered By] as [Delivered_By],[How to Access] as [How_to_Access],[Contact Name] as [Contact_Name],[Contact Number] as [Contact_Number],[Contact email] as [Contact_email],[Website],[Geographical area] as [Geographical_area],[Type],[Start Date] as [Start_Date],[End Date] as [End_Date] from [Master] as [Master]" queryAllowed="yes" name="Master"></xsf:adoAdapter>

</xsf:query>

</xsf:dataObject>

<xsf:dataObject name="Master 2" schema="Master 2.xsd" initOnLoad="yes">

<xsf:query>

<xsf:sharepointListAdapter siteUrl="https://monmenaiemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com/" sharepointGuid="{51347A40-9A5A-4169-A4A0-1BACD4AAA095}" infopathGroup="Master" queryAllowed="yes" submitAllowed="no" name="Master 2">

<xsf:field sharepointName="Title" infopathName="Funded_By"></xsf:field>

<xsf:field sharepointName="Provision_x0020_" infopathName="Provision_"></xsf:field>

<xsf:field sharepointName="Target_x0020_Group" infopathName="Target_Group"></xsf:field>

<xsf:field sharepointName="Description_x0020_of_x0020_Provi" infopathName="Description_of_Provision"></xsf:field>

<xsf:field sharepointName="Delivered_x0020_By" infopathName="Delivered_By"></xsf:field>

<xsf:field sharepointName="How_x0020_to_x0020_Access" infopathName="How_to_Access"></xsf:field>

<xsf:field sharepointName="Contact_x0020_Name" infopathName="Contact_Name"></xsf:field>

<xsf:field sharepointName="Contact_x0020_Number" infopathName="Contact_Number"></xsf:field>

<xsf:field sharepointName="Contact_x0020_email" infopathName="Contact_email"></xsf:field>

<xsf:field sharepointName="Website" infopathName="Website"></xsf:field>

<xsf:field sharepointName="Geographical_x0020_area" infopathName="Geographical_area"></xsf:field>

<xsf:field sharepointName="Type" infopathName="Type"></xsf:field>

<xsf:field sharepointName="Start_x0020_Date" infopathName="Start_Date"></xsf:field>

<xsf:field sharepointName="End_x0020_Date" infopathName="End_Date"></xsf:field>

<xsf:field sharepointName="ID" infopathName="ID"></xsf:field>

</xsf:sharepointListAdapter>

</xsf:query>

</xsf:dataObject>

</xsf:dataObjects>

<xsf:ruleSets>

<xsf:ruleSet name="ruleSet_1">

<xsf:rule caption="Switch to View 2" isEnabled="yes">

<xsf:switchViewAction view="View 2"></xsf:switchViewAction>

</xsf:rule>

</xsf:ruleSet>

<xsf:ruleSet name="ruleSet_2">

<xsf:rule caption="Switch to View 1" isEnabled="yes">

<xsf:switchViewAction view="View 1"></xsf:switchViewAction>

</xsf:rule>

</xsf:ruleSet>

<xsf:ruleSet name="ruleSet_3">

<xsf:rule caption="Rule 1" isEnabled="yes">

<xsf:assignmentAction targetField="my:CurrentRecordNumber" expression=""1""></xsf:assignmentAction>

</xsf:rule>

</xsf:ruleSet>

<xsf:ruleSet name="ruleSet_4">

<xsf:rule caption="Rule 1" isEnabled="yes">

<xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="count(dfs:dataFields/d:Master)"></xsf:assignmentAction>

</xsf:rule>

</xsf:ruleSet>

<xsf:ruleSet name="ruleSet_5">

<xsf:rule caption="Rule 1" condition="my:CurrentRecordNumber > 1" isEnabled="yes">

<xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="xdMath:Nz(my:CurrentRecordNumber) - 1"></xsf:assignmentAction>

</xsf:rule>

</xsf:ruleSet>

<xsf:ruleSet name="ruleSet_6">

<xsf:rule caption="Rule 1" condition="my:CurrentRecordNumber < count(dfs:dataFields/d:Master)" isEnabled="yes">

<xsf:assignmentAction targetField="my:CurrentRecordNumber" expression="xdMath:Nz(my:CurrentRecordNumber) + 1"></xsf:assignmentAction>

</xsf:rule>

</xsf:ruleSet>

</xsf:ruleSets>

<xsf:query>

</xsf:query>

<xsf:submit caption="Su&bmit">

<xsf:useQueryAdapter></xsf:useQueryAdapter>

</xsf:submit>

</xsf:xDocumentClass>

Re: data connection

Hilary Stoupa — Wed, 11 Jan 2012 16:32:08 GMT

Well - you can certainly hire us to help with that - we do offer paid InfoPath support, and you can learn more about our services here.

However, the work is more complex than something I'd be able to help with ad hoc via the forum. I did get a reply to my email suggesting that it may be possible to remove the database dependency with manual modifications to the manifest of the template - you may want to save your form as source files and look through the manifest.xsf file - perhaps compare it to a new blank form and you'd be able to see a difference that you could modify to remove the database dependency. The other option that was suggested was to create a new template off the schema of the current template, copy over the views and rebind the items.

At that point, depending on the complexity of the template, it may truly be the easiest to just start over.

Re: data connection

Dafydd — Wed, 11 Jan 2012 09:34:23 GMT

Ok great thank you for your help with this

Would it be possible for me to send you the InfoPath form along with the required log in details for my SharePoint site (trail version Microsoft online services) would you or your colleagues be able to publish it to the site and configure it to open in InfoPath (users with InfoPath software) and as a (browser enabled form) for those who don’t have InfoPath software?

I’m genuinely stuck with this and would love to get it working correctlyThanks,

Daf

Re: data connection

Hilary Stoupa — Tue, 10 Jan 2012 23:01:21 GMT

If it is the main data connection, you may just have to rebuild your form - I'll email the smart people I work with and see if any of them know of a way around that.

Re: data connection

Dafydd — Tue, 10 Jan 2012 08:25:18 GMT

the remove button is not available to press so i guess it is the main connection !

is there anything I can do ??

Also Im having problems publishing to a sharepoint site so that clients can access the form with Infopath on their own machines.

Re: data connection

Hilary Stoupa — Tue, 10 Jan 2012 00:27:11 GMT

What happens when you try to remove the data connection? It isn't the main data connection, is it?

data connection

Dafydd — Tue, 10 Jan 2012 00:07:27 GMT

im trying to prep my form so that its compatible as a browser enabled form I have 1 error left that i cant get rid - cant (querying access database is not allowed) i have tried to remove the data connection to the database but cant remove it.

i have uploaded my lists to sharepoint that i want to query add, remove data through the browser.

im really stuck with this and would appriciate any help available

many thanks

daf