Cannot Set Access Data Source to ReadOnly=0;

[LuminaryXion]

I'm new to these forums so please forgive me if I've chosen the wrong area to post this question in.

I am struggling with an excel connections issue. I share a database with my coworkers and I am trying to use an access data source connection to retrieve data from the database for use in the files I have to print off every day. The system is working like a charm, however when I have the excel file open, if my coworker opens the the database they will find it has been locked into read only mode. I am not making any changes to the access tables, just retrieving data. I am not a programmer, so I am not comfortable making a VBA based connection and because this is my company's database I can only share some parts of the code.

I have researched online that maybe I need to add "ReadOnly=0;" to the connection's properties, but when I do the number always changes to 1, it won't stay at 0.

Here is what I can show you of the connection source;

DSN=MS Access Database;DBQ=<database>.mdb;DefaultDir=<database location folder>;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;ReadOnly=1;

The ReadOnly=1; at the end was not there at first, I added "ReadOnly=0;" and when I opened it again it had changed to 1.

I have 3 active connections for three access tables that I am pulling data from, the first two look like this one, the 3rd is an MSQuery connection where I am using a connection that looks like this;

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=<database>.mdb;Mode=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False

I'm sorry if this is too much information, I'm really not sure which part is the actual source of my problem, but the final goal is that I need to be able to have this excel.xlsm file pull information like it is now and stay open while I edit the file but not lock the other users in my company while I'm doing it.

Thank you for any help.

[LuminaryXion]

Nobody has any ideas? I've been researching and I found something that seems to have resolved the issue. Still tinkering. I changed the MSQuery with the following two arguments:

Mode=Share Deny None;Jet OLEDB:Database Locking Mode=1;

Which I found on a website (am I allowed to link to other websites here? I will if it's okay) describing advice for improving the shareability of access queries. Hopefully that was the issue. Gonna tinker some more and make sure it's all clear.