We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

I got error "The connection to the data source "DB file name" could not be established." [closed]

asked 2018-04-11 03:28:24 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to open and edit a .mdb file created by MS Access earlier than 2007, so I launched sbase.exe and go over 1st and 2nd step by picking 'Connect to existing database' then picked 'Microsoft Access' which will give .mdb file type in explorer dialog window, but then next I got the message "The connection to the data source "DB file name" could not be established. The connection could not be created. May be the necessary data provider is not installed."

my spec Windows 10 Pro 64 bit Libre Office 64 bit 6.0.32

Has anyone solved such this and sincerely would share it to me so will benefit from it ?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-05-05 16:46:57.492456


Please do not post as wiki. It helps no one.

Ratslinger gravatar imageRatslinger ( 2018-04-11 04:19:21 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-04-11 04:26:17 +0200

Ratslinger gravatar image

updated 2018-04-11 17:37:57 +0200

Hello @Abdan,

Connecting with Access in Windows using 64-bit LO & built-in connection does not work. There is an outstanding bug report on this.

You have two choices to connect. Install a 32-bit version of LO & 32-bit JRE and the connection will work.

Another solution using your existing 64-bit LO is to use a JDBC connection.

To do so, see my answer int this post -> mdb files not loading to base.

Edit 2018-04-11:

Although I have not tried/tested it, there may be a third solution. That is to to download 'Microsoft Access Database Engine 2016 Redistributable'. Please see Bug 107360. Refer to comments 10, 11 & 13.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-11 03:28:24 +0200

Seen: 2,297 times

Last updated: Apr 11 '18