https://bugs.documentfoundation.org/show_bug.cgi?id=114794
Bug ID: 114794
Summary: LibreOffice will no longer recognise my Access
database
Product: LibreOffice
Version: 5.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
One last effort to get LibreOffice Base working again, otherwise I may be
compelled to find another program. During previous efforts, it has been
suggested that I have not always provided the detailed information that the
very patient responders could have used to solve my problem; this time I will
do my best to tell you everything.
Towards the beginning of December, I was happily updating my database, which is
a LibreOffice Base database (entitled REFS3) but based on a Microsoft Access
(mdb, not 2016) database (entitled REFS2), when LibreOffice stopped responding.
In the past, I have always found that this indicates that an update is
available, so I updated LibreOffice - to version 5.3.7.2 x64. From that
moment, though I can open the opening screen of REFS3, as soon as I select a
table (or query or report), all I get is a pop-up window stating ‘The
connection to the data source REFS3 could not be established. The connection
could not be created. Perhaps the necessary data finder has not been
installed’.
On seeking help, I was told that LO 5.3.7.2x64 is a 64 bit version and
therefore requires a 64 bit Java JRE. So I upgraded Java to Oracle version
1.8.0_151 which I am assured is a 64 bit version. After several more days of
effort, I managed to get the JRE which Java said was installed to appear on the
LO Java Options screen (Tools, Options, Advanced), and further that the
Parameters screen and the Class Path screen are both empty. I have ensured
that both databases REFS3 and REFS2 are registered, that Microsoft Access and
the correct address of the REFS2 database appear at the bottom of the opening
screen of REFS3, that REFS2 and REFS3 are both set to open with LO Base.
But despite all this advice and action, all I get when I open REFS3, and select
a table, is that pesky pop-up window mentioned above
What I have not altered is the LO /tools/options/LibreOffice Base Connections
screen. The current connection is com.sun.star.comp.sdbc.ODBCDriver.
Connection pooling is enabled, but pooling is set to NO on all the entries.
The problem is not fixed by going into Safe Mode.
If anyone can advise me on how to get my database working again, I would be
very grateful. Actually, I have three similar databases, but this one is the
most complex (three tables) and if this one gets fixed, I reckon I will be able
to sort out the other two.
Steps to Reproduce:
1.Enter LibreOffice
2.Select REFS3 database
3.Select any table, query or report
Actual Results:
The pop-up window described above appeared
Expected Results:
The appearance of the table.query/report on screen
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows 10 Home
OS is 64bit: yes
Version: 5.3.7.2 (x64)
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new;
Locale: en-GB (en_GB); Calc: group
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0
--
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
