Configure MS Access Driver in ODBC Data Sources to be read only

Natasha Pilypaitis 0 Reputation points
2023-02-20T23:38:24.26+00:00

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;

odbc_setup_screen_shot

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.