I have files created in LO, as well as mdb files created in Access on my PC. I don’t have Access installed. Never had a problem working on the files before, but now I get an error saying that the connection to the data source “” could not be established. “The connection could not be created. May be the necessary data provider is not installed.” In the error details pane, it shows an error of "SQL Status: HY000, with the same description as above. I’m guessing someone else has experienced this, but my searches have yielded nothing but confusing info. Anybody out there know how to resolve this? Thanks!
Try reinstalling LO or Java.
I reinstalled LO (no help), but I stopped running Java on my PC a long time ago.
I uninstalled LO 64-bit, and installed 32-bit. I can now see .odb files, but it tries to open .mdb files in Writer. I also installed Java, to see if that might help. It didn’t.
Same problem here, I can open the ODB file, but this file has a connection to a MDB file, and for any form or table I try to open I get the same error. The very same file works perfectly on Windows 7 and even XP (32-bit), but doesn’t work on Windows 10 (64-bit).
I’ve already installed several versions of AccessRuntime and AccessDatabaseEngine, but any could help.
I guess something was done wrong in LO 64bit.
Ok. The bad news is connections to access files doesn’t work on LO 64-bit (I don’t know why). As I said on my comment few minutes ago, I’ve been experiencing the same problem here. But haven’t tried to install LO 32-bit yet (even on Win10 64-bit). And here come the good new. The connections to access files still normally on LO 32-bit on a SO 64-bit.
What’s wrong for you is that you really won’t open a MDB file directly on Base (afaik, it never worked this way), you need to create an ODB file and make the connection to the MDB file within it. On Database Wizard (sorry if the names are wrong, I use pt-BR localization), select “connect to an existing database”, then select “Microsoft Access”, click “Next”, Browse to the MDB file, click “Next” and “Conclude”, then select a name for your new ODB file.
Both MDB and ODB will coexist. The tables will keep being in MDB file, but I think all the rest (forms, queries and reports) you’ll have to (re)create in ODB file.
The 64-bit Microsoft Access Database Engine Redistributable cannot be installed if you have 32-bit MS Office product installed btw