https://bugs.documentfoundation.org/show_bug.cgi?id=157561
--- Comment #5 from [email protected] --- Item #1: I should have printed the entire messages The file 'Hymns.mdb' is corrupt and therefore cannot be opened. LibreOffice can try to repair the file. The corruption could be the result of document manipulation or of structural document damage due to data transmission. We recommend that you do not trust the content of the repaired document. Execution of macros is disabled for this document. Should LibreOffice attempt to repair the file? This message is in error because the file is NOT CORRUPT. The same happens with .accdb files. These files are processable by MS Access and have valid internal signatures in the files: x(000100) + "Standard Jet DB" for .mdb; x(000100) + :Standard ACE DB" for .accdb. LibreOffice should either open it (as such utilities as MDBViewer can) or otherwise the messages should be "File type .xxxxx is not supported for direct reading" or some such. Item #2: Re reply to Ilya: connecting a new .odb file to Hymns.mdb, going through the process and using the table wizard, I get the message The connection to the data source "Hymns" could not be established. The connection could not be created. Maybe the necessary data provider is not installed? More … on clicking More I get the additional message SQL Status: HY000 The connection could not be created. Maybe the necessary data provider is not installed? on exiting this message (the first time only, afterwards unless you delete the .odb file, then you do not) you get this message JRE Required LibreOffice requires a 64-bit Java runtime environment (JRE) to perform this task. Please install a JRE and restart LibreOffice. https://hub.libreoffice.org/InstallJava/?LOlocale=en-GB installed the right JRE and same result. Checked the ODBC Data Source Administrator (64-bit) and found, among others that for MS Access Database on 64-bit Platform there is installed "Microsoft Access Driver (*.mdb, *.accdb). Surely you don't have to set up System DSN for each file! -- You are receiving this mail because: You are the assignee for the bug.
