[Issue]Unable to open an Access database (MDB) with LO 3.4
- jeanmi2403
- Posts: 29
- Joined: Tue Jan 29, 2008 12:37 pm
- Location: Sucy en Brie (France)
[Issue]Unable to open an Access database (MDB) with LO 3.4
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,
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 451 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
Reason: tagged as [Issue], Moved to LibreOffice
Jean-Michel
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
Re: Unable to open an Access database (MDB) with LibreOffice
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
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Unable to open an Access database (MDB) with LibreOffice
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.
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- jeanmi2403
- Posts: 29
- Joined: Tue Jan 29, 2008 12:37 pm
- Location: Sucy en Brie (France)
Re: Unable to open an Access database (MDB) with LibreOffice
Hello,
Friendly
And why it works there with LibreOffice 3.3?Villeroy wrote:you can not expect strictly proprietary Microsoft drivers shipped with a free office suite.
Friendly
Jean-Michel
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
Re: Unable to open an Access database (MDB) with LibreOffice
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.
"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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Unable to open an Access database (MDB) with LibreOffice
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.
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
Hungarian forum co-admin
Re: Unable to open an Access database (MDB) with LibreOffice
Is ODBC a viable alternative?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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Unable to open an Access database (MDB) with LibreOffice
Yes, ODBC still working with mdb files, and others.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
-
- Posts: 2
- Joined: Mon Jul 04, 2011 6:29 pm
Re: Unable to open an Access database (MDB) with LibreOffice
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
Re: Unable to open an Access database (MDB) with LibreOffice
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.rbowenkamp wrote: I really don't care about whether MS will support Linux.
Yes, it is. It is unlikely that this can be fixed soon since there is not a single Base developer in the LibreOffice team.Is this a "bug" in the current version of LibreOffice
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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 2
- Joined: Mon Jul 04, 2011 6:29 pm
Re: Unable to open an Access database (MDB) with LibreOffice
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.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]
LibreOffice 3.4.1 on Windows 7
- jeanmi2403
- Posts: 29
- Joined: Tue Jan 29, 2008 12:37 pm
- Location: Sucy en Brie (France)
Re: Unable to open an Access database (MDB) with LibreOffice
Good evening,
Indeed, ODBC allows access. It's a bit longer to implement, but it works. Thank you for the method!
Sincerely,
Indeed, ODBC allows access. It's a bit longer to implement, but it works. Thank you for the method!
Sincerely,
Jean-Michel
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX
LibO 7.4.7 and AOO 4.1.14 on Windows 10 x64, Windows 11 & Ubuntu 22.04
LibO 7.5 on OpenSuse & Linux MX