Sign in
 
HomeSharePoint Server 2010SharePoint Foundation 2010SharePoint OnlineLibraryForums
SharePoint Products > SharePoint Products and Technologies Forums > SharePoint - Business Data Catalog (pre-SharePoint 2010) > Accessing MSAccess Database using BDC

Unanswered Accessing MSAccess Database using BDC

    •  
      Monday, January 29, 2007 9:23 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi,

      Does anyone knows how to access MSAccess database using BDC (Business Access Database) with MOSS 2007.

       

       

    All Replies

    • Monday, March 19, 2007 1:49 PM
       
       
      Sign In to Vote
      1
      Sign In to Vote

      I got the BDC working with Access 2007. Here is the LobSystemInstance I used to get this working:

        <LobSystemInstance Name="MyInstanceName" DefaultDisplayName="MyDisplayName">
            <LocalizedDisplayNames>
              <LocalizedDisplayName LCID="1033">English Display Name</LocalizedDisplayName>
            </LocalizedDisplayNames>
            <Properties>
              <Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property>
              <Property Name="DatabaseAccessProvider" Type="System.String">Odbc</Property>
              <Property Name="RdbConnection Data Source" Type="System.String">Data Source='';Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\server\share\database.accdb;Trusted_Connection=true;</Property>
              <Property Name="RdbConnection Integrated Security" Type="System.String">False</Property>
            </Properties>
          </LobSystemInstance>

      I hope this helps!