Cannot Set Access Data Source to ReadOnly=0;
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.
Re: Cannot Set Access Data Source to ReadOnly=0;
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1