[Issue]Unable to open an Access database (MDB) with LO 3.4

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

[Issue]Unable to open an Access database (MDB) with LO 3.4

Postby jeanmi2403 » Mon Jul 04, 2011 3:26 pm

Hello,
I get regular MSAccess databases, and I read with Base, waiting to rebuild completely.
I have seen with Lo 3.4, you can not read MSAccess databases. This fact will it last, or is it simply because the development is completed?
The bug has been post.... since no news
https://bugs.freedesktop.org/show_bug.cgi?id=38765
To reproduce the bug:
- File / New / Database
-Connect to an existing database
- Microsoft Access drop-down list (so far it's going ....)
- Next and then select the file (I put a sample file attached)
- Patatras! DataPilot not found ... (I can not remember the exact message, rage, I'm back with 3.3)

It is a shame to show this feature and it is not operational!

Sincerely,
Attachments
Bidon.zip
(5.21 KiB) Downloaded 268 times
Last edited by Villeroy on Mon Jul 04, 2011 11:24 pm, edited 1 time in total.
Reason: tagged as [Issue], Moved to LibreOffice
Jean-Michel
LibreOffice 5.1.6 and OpenOffice 4.1.3 / Windows 7 / Windows 10
User avatar
jeanmi2403
 
Posts: 16
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)

Re: Unable to open an Access database (MDB) with LibreOffice

Postby Villeroy » Mon Jul 04, 2011 4:10 pm

No matter which database you connect to, in most cases you need the database drivers from the database vendor. There are some of the free database drivers shipped with this office suite but you can not expect strictly proprietary Microsoft drivers shipped with a free office suite.
All about Access
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to open an Access database (MDB) with LibreOffice

Postby Villeroy » Mon Jul 04, 2011 4:11 pm

No matter which database you connect to, in most cases you need the database drivers from the database vendor. There are some of the free database drivers shipped with this office suite but you can not expect strictly proprietary Microsoft drivers shipped with a free office suite.
All about Access
There are drivers downloadable from the Microsoft site for Windows system only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to open an Access database (MDB) with LibreOffice

Postby jeanmi2403 » Mon Jul 04, 2011 4:24 pm

Hello,
Villeroy wrote:you can not expect strictly proprietary Microsoft drivers shipped with a free office suite.

And why it works there with LibreOffice 3.3?
Friendly
Jean-Michel
LibreOffice 5.1.6 and OpenOffice 4.1.3 / Windows 7 / Windows 10
User avatar
jeanmi2403
 
Posts: 16
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)

Re: Unable to open an Access database (MDB) with LibreOffice

Postby Villeroy » Mon Jul 04, 2011 4:34 pm

Because "there" they have the Microsoft package installed and it would work with any version of OpenOffice.org and dozends of other database applications as well. The drivers are frequently used with database applications on CD Rom (catalogues, diet plans, cooking recipes, budgeting tools).

"Here" it will never work because Microsoft does not publish these drivers for operating systems other than Windows.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to open an Access database (MDB) with LibreOffice

Postby r4zoli » Mon Jul 04, 2011 4:50 pm

The LibO 3.4.1 under win7 I tested I get missing SDBC driver error, opened existing mdb connected odb file, or created new one, when I clicked on Tables pane in database window.
It means the program was created wrongly, not contains existing driver in other versions.

The LibO team not contain developer and QA resource to catch such type of bugs.
The Base part will be less usable after each new version of LibO.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Unable to open an Access database (MDB) with LibreOffice

Postby Villeroy » Mon Jul 04, 2011 4:56 pm

r4zoli wrote:The LibO 3.4.1 under win7 I tested I get missing SDBC driver error, opened existing mdb connected odb file, or created new one, when I clicked on Tables pane in database window.

Is ODBC a viable alternative?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to open an Access database (MDB) with LibreOffice

Postby r4zoli » Mon Jul 04, 2011 5:30 pm

Yes, ODBC still working with mdb files, and others.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Unable to open an Access database (MDB) with LibreOffice

Postby rbowenkamp » Mon Jul 04, 2011 6:41 pm

I am still confused. Using a computer with Windows 7 and LibreOffice 3.3.x I am able to work with an Access 2003 database with no problems. Using the same Windows 7 computer and LibreOffice 3.4.1 I am not able to work with the same Access 2003 database. I get all the symptoms noted in the earlier comments. I really don't care about whether MS will support Linux. Is this a "bug" in the current version of LibreOffice or is it a "feature" which will mean I can no longer easily operate on my older Access databases and may want to rethink use of LibreOffice? If this is a "feature", then is there a way for a user to regain the lost functionality - explained in terms a LibreOffice user (not a code pig) can understand and implement?
LibreOffice 3.4.1 on Windows 7
rbowenkamp
 
Posts: 2
Joined: Mon Jul 04, 2011 6:29 pm

Re: Unable to open an Access database (MDB) with LibreOffice

Postby Villeroy » Mon Jul 04, 2011 7:04 pm

rbowenkamp wrote: I really don't care about whether MS will support Linux.

This topic will be read by hundreds of others and one of the most frequent questions is why Access can not be used outside Windows.

Is this a "bug" in the current version of LibreOffice

Yes, it is. It is unlikely that this can be fixed soon since there is not a single Base developer in the LibreOffice team.

You can still set up an ODBC connection in the system panel and plug Base to that ODBC data source.
[*.mdb]<->[MS Drivers]<->[ODBC Plug]<->[Some database program like OOo]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to open an Access database (MDB) with LibreOffice

Postby rbowenkamp » Mon Jul 04, 2011 8:33 pm

Is this a "bug" in the current version of LibreOffice

Yes, it is. It is unlikely that this can be fixed soon since there is not a single Base developer in the LibreOffice team.

You can still set up an ODBC connection in the system panel and plug Base to that ODBC data source.
[*.mdb]<->[MS Drivers]<->[ODBC Plug]<->[Some database program like OOo]


Thank you for timely and clear response. I setup Access db for ODBC connection and it worked very smoothly. Now I can continue to work with LibreOffice base until the "bug" is fixed.
LibreOffice 3.4.1 on Windows 7
rbowenkamp
 
Posts: 2
Joined: Mon Jul 04, 2011 6:29 pm

Re: Unable to open an Access database (MDB) with LibreOffice

Postby jeanmi2403 » Mon Jul 04, 2011 11:14 pm

Good evening,
Indeed, ODBC allows access. It's a bit longer to implement, but it works. Thank you for the method!
Sincerely,
Jean-Michel
LibreOffice 5.1.6 and OpenOffice 4.1.3 / Windows 7 / Windows 10
User avatar
jeanmi2403
 
Posts: 16
Joined: Tue Jan 29, 2008 12:37 pm
Location: Sucy en Brie (France)


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 1 guest