I had the same issue with connecting to .accdb files. After trying a few things, I ended up using unidac and it worked good. It supports both .mdb and .accdb formats, and I was able to read/write to the database without any problems. If you're stuck with this, you can check it.