SQL Updates on OneDrive Workbook

[hamiltpj]

Hi there,

When trying to run a sql update statement (on a sheet) that works fine locally, I get 'Cannot update. Database or object is read-only' when I move it on to OneDrive. My assumption is that it's because of co-authoring.

My connection string is:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ThisWorkbook.fullname+ ";Extended Properties=""Excel 12.0;HDR=Yes"";"

Does anyone know of a way around this? I tried to install the v16.0 driver but it wouldn't let me.

Thanks,

Pete