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

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

RamJacCorp
1 ●2 ●3 ●2

updated 2020-10-25 18:40:24 +0100

flag of United Kingdom of Great Britain and Northern Ireland

20859 ●19 ●60 ●59 http://etmg.altervista...

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-12 12:16:47.431305

Comments

Try reinstalling LO or Java.

Mike 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 ( 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 ( 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 ( 2018-01-06 03:16:43 +0100 )edit

add a comment

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

MarvinMep
1 ●1 ●1 ●1

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.

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 ( 2018-01-06 09:42:12 +0100 )edit

add a comment

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

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-12 12:16:47.431305

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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

Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2021-02-12 12:16:47.431305

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-12 12:16:47.431305