Ask Your Question
0

After latest Win 10 update, LO 5.3 won't open mdb or odb files

asked 2017-09-13 22:10:17 +0100

RamJacCorp gravatar image

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 "<database name="">" 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!

edit retag flag offensive close merge delete

Comments

Try reinstalling LO or Java.

Mike Kaganski gravatar imageMike Kaganski ( 2017-09-13 22:30:40 +0100 )edit

I reinstalled LO (no help), but I stopped running Java on my PC a long time ago.

RamJacCorp gravatar imageRamJacCorp ( 2017-09-14 04:10:00 +0100 )edit

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.

RamJacCorp gravatar imageRamJacCorp ( 2017-09-16 21:37:03 +0100 )edit

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.

MarvinMep gravatar imageMarvinMep ( 2018-01-06 03:16:43 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-06 03:47:47 +0100

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.

edit flag offensive delete link more

Comments

Well, actually googling for access driver 64 bit gives this in the first lines.

The 64-bit Microsoft Access Database Engine Redistributable cannot be installed if you have 32-bit MS Office product installed btw :)

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-06 09:42:12 +0100 )edit
Login/Signup to Answer

Question Tools

4 followers

Stats

Asked: 2017-09-13 22:10:17 +0100

Seen: 96 times

Last updated: Jan 06