Using the older From Access button, I used to make the connections to Access read only before they were created. Otherwise, I end up not being able to save my Access VBA in that database until I close Excel.
With this newer type of connection, I haven't figured out how to do it. It's not obvious how to do so with the connection string itself. I found that the extended properties are both Base64 encoded and compressed. That was enough to stop me from pursuing that option.
Really, I don't understand why these connections aren't read only as default. As far as I can tell, there's no writeback ability with any of these things anyway, at least not with Access. It's very problematic, especially when you get multiple users.
In addition to the poor choice of default, did they really leave us without the option?
With this newer type of connection, I haven't figured out how to do it. It's not obvious how to do so with the connection string itself. I found that the extended properties are both Base64 encoded and compressed. That was enough to stop me from pursuing that option.
Really, I don't understand why these connections aren't read only as default. As far as I can tell, there's no writeback ability with any of these things anyway, at least not with Access. It's very problematic, especially when you get multiple users.
In addition to the poor choice of default, did they really leave us without the option?
