Both ODBC and DAO work well for MS-Access.   Be sure that you have an up-to-date version of that software on the computer you are using.

As far as I am aware, you must have a copy of Access on your computer ... although you might find that you can reach the file using Excel, which would mean that you at-least have JET available.

If you are using only the JET database engine portion, consider alternatives.   There are equally capable SQL implementations out there for desktops, both from MS and otherwise.   As far as I can see, Jet, good as it is|was, is today a more-or-less moribund technology.   I would make it my business to transition away from it.