You must Sign In to post a response.
  • Category: General

    Error in Recordset object during data fetching from MOSS

    Hello All,

    Do you have any code snippet so that VBA application can read the value from the access database(.accdb file) residing in share point portal?

    I have tried with following code snippet.



    Dim con As New ADODB.Connection
    Dim rs As New ADODB.Recordset

    con.Open ConnectionString:="Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;DATABASE=<moss url>;LIST={GUID};"

    rs.Open "SELECT * FROM [Table];", con



    But the following error is coming when rescordset object is trying to open the table.

    ---------------------------
    Microsoft Visual Basic
    ---------------------------
    Run-time error '-2147467259 (80004005)':

    Automation error
    Unspecified error
    ---------------------------
    OK Help
    ---------------------------

    Any idea?

    Regards,
    Sumit
  • #760181
    Hi

    you can go through below link for read the value from the access database(.accdb file) residing in share point portal

    First access provider install for your pc then you can access your application to accdb

    https://support.office.com/en-au/article/Which-Access-file-format-should-I-use--012d9ab3-d14c-479e-b617-be66f9070b41?ui=en-US&rs=en-AU&ad=AU


    http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_27475708.html

    http://vb.knowcoding.com/view/482153-unable-to-import-microsoft-sharepoint-portal.html

    Hope it will be helpful to you

    Name : Dotnet Developer-2015
    Email Id : kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.


  • Sign In to post your comments