$$Excel-Macros$$ Re: OpenSchema fails when connecting to a persisted recordset

2015-05-20 Thread Dominic Marshall
Hi, Just an update on this. I thought I would try this in Access so added the following code to test this: Set conn = New ADODB.Connection conn.Provider = "MSDataShape" conn.Open "Data Source=Test" Set rs = New ADODB.Recordset rs.Open shape, conn, adOpenStatic, adCmdText

$$Excel-Macros$$ Re: OpenSchema fails when connecting to a persisted recordset

2015-05-18 Thread Dominic Marshall
Further to this the same error occurs if I try to use the recordset to get the same information Set myRecordset = New ADODB.Recordset myRecordset.Open "C:\Temp\cust.xml", "Provider=MSPersist", adOpenUnspecified, adLockUnspecified, adCmdFile Set TableSchema = myRecordset.ActiveCon