have a code that connect to a shrepoint list and update it. It works perfectly in many computers.
But, some others, I get an error
"Could not find installable isam ('-2147467259 (80004005)')"
I tried to find solutions, but the post that would help me didn't have any answer. Can you explain how to fix it?
But, some others, I get an error
"Could not find installable isam ('-2147467259 (80004005)')"
I tried to find solutions, but the post that would help me didn't have any answer. Can you explain how to fix it?
VBA Code:
Dim cnt As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim ObjNetwork
Set ObjNetwork = CreateObject("WScript.Network")
mySQL = "SELECT * FROM [" & material & "];"
With cnt
.ConnectionString = _
"Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;DATABASE=" & site & ";LIST=" & list & ";"
.Open
End With
rst.Open mySQL, cnt, adOpenDynamic, adLockOptimistic