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