Hello Excel users!

This is how it looks:

[DATABASE] - xlsx file on server

[USER A] [USER B] ... [USER X] - xlsm

User or application refresh database by a standard macro:

Please Login or Register  to view this content.
Connection string in query table:

Please Login or Register  to view this content.
It works perfectly, but there is a glitch that really pisses me off.

When user's application is saving data, macro goes like this:
- if database file is currently in read only mode, tell user and exit sub
- open workbook
- input/update data
- save workbook

The problem is:

If user A would like to refresh querry, and in the same moment database is currently updated (hence opened) by user B, Excel ALWAYS opens database workbook in readonly mode on user A machine. How to prevent it?

Should I use other driver than ACEODBC12? I tried diffrent drivers but it always opens freaking workbook on refresh, despite parameters, connection etc.

For example, Libra office has no problems with that, but I rather stick to Excel

Any directions would by greatly appreciated!