https://bugs.documentfoundation.org/show_bug.cgi?id=121024
Bug ID: 121024
Summary: Document usage of Microsoft Access Database
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
We had a number of bugs for usage of Microsoft Access Database:
Bug 107360, Bug 114794, Bug 97395, Bug 97579, Bug 107890.
Thanks to Alex, some of them were closed with the following explanation:
Microsoft no longer provides for reading/writing to a 32bit Access db (versions
created with Access 97, 2003) on its 64bit systems. There is information about
this on both MSND, and Microsoft's own knowledgebase websites.
On a 64bit OS with 64bit programs, MS no longer supports 32bit access to Access
MDB files made on a 32bit system (see MS' own support forums and the MSDN
forums).
As LO relies on Microsofts own drivers to do this, Access97 and Access2003
files are no longer accessible with 64bit LO. If there is no MS support, there
is not much we can do.
All-64bit setup works :
- 64bit OS
- 64bit accdb Access >= 2010
- 64bit Access Database Engine (2016) - database drivers provided by MS
There was some workaround mentioned, I didn't test:
There is a way to do this in 64-bit if you use a JDBC connector - UCanAccess:
https://ask.libreoffice.org/en/question/145877/mdb-files-not-loading-to-base/
May exist a problem of passing the required parameter into the database in
order to create the report. Create a single record table containing that
parameter, and connect that into the database.
We still have Bug 43187.
I didn't find a proper documentation, just
https://help.libreoffice.org/6.2/en-US/text/shared/explorer/database/dabawiz02access.html
I suggest it be created. We may rely on wiki page
https://wiki.documentfoundation.org/MSA-Base_Faq
Now it just points to https://wiki.openoffice.org/wiki/MSA-Base_Faq which I
find wrong. We should explain all what we can here, using and updating info
that one and https://wiki.openoffice.org/wiki/Connecting_to_Microsoft_Access.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
