Configure MS Access Driver in ODBC Data Sources to be read only
Without getting too deep in the weeds, I have an MS Access database (.accdb) and I needed to create a System DNS connection to it in ODBC Data Sources. Did that it works can connect to it and query it, get results all gravy.
However, it is kinda demanding to get the first exclusive access and if someone else already has a lock file for the database it say, well now I'm not doing it. And I don't really accept that attitude, I really only the the ODBC connection to it to just read the database, even if someone else is operating it first and created a lock file.
Anyone know if/where I can configure it to still read the database even if a lock file exists?
I feel like it should be here, but idk;