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

  • Question

  • 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.

    Friday, November 29, 2019 2:39 PM

All replies

  • Hi,

    According to your description, your issue is more related about VBS. And this forum is discussing and asking questions about the vb.net.

    Ask in the following forum.


    Thank you for your understanding.

    Thank you for participating in the forum activities.

    Best Regards,


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, December 2, 2019 6:36 AM