Jet.OLEDB.4.0 Connection creates READ-ONLY COPY of referenced EXCEL file

  • Thread starter Thread starter ChrisJohnD
  • Start date Start date
C

ChrisJohnD

Guest
Running VB script in Excel 16.0 (Part of Office 365 ProPlus 32 bit), when connection is created in VB, a READ ONLY copy of the referenced file is created straight after connection opened:

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" + Filename + ";" & _
"Extended Properties=Excel 8.0"

This has only occurred after a recent Office update, we are reasonably sure of? Need help to stop this.

Continue reading...
 
Back
Top