Bug 106845 - Macro code in password protected module in Base suddenly gone
Summary: Macro code in password protected module in Base suddenly gone
Status: RESOLVED DUPLICATE of bug 93749
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2017-03-29 08:44 UTC by Gerhard Schaber
Modified: 2017-04-06 10:07 UTC (History)
0 users

See Also:
Crash report or crash signature:

DB file with missing macro library (57.62 KB, application/vnd.sun.xml.base)
2017-03-29 08:44 UTC, Gerhard Schaber

Note You need to log in before you can comment on or make changes to this bug.
Description Gerhard Schaber 2017-03-29 08:44:40 UTC
Created attachment 132246 [details]
DB file with missing macro library

I have a ODB file with a password protected Basic library and dialogs. I did some changes in a query and reports, saved the file, and closed it. Later, when I opened the file again. I noticed that the code of the password protected Basic library was empty. Only the dialogs were still there, and the empty Basic library. The database including queries and reports were fine.

I cannot provide you with the Basic module or the database, but I have attached the remainder of the file (before the upload I emptied out the tables and queries as well, and the backup folder). Maybe there is some indication of the problem.

I cannot reliably reproduce this, but it happened twice and it is a little worrying that data can be lost. 

I quite often see the database gets lost, and this happens quite frequently when browsing tables and changing their filters and sorting a lot. At some point it would only store a defective file with the whole database missing. But then I would notice it right away.

But when losing the macro library at some point, I do not notice it right away, and if there are a lot of database changes in between, it is troublesome to merge a file with a good macro library with a file with a good database.
Comment 1 Gerhard Schaber 2017-03-29 08:59:27 UTC
I am not sure, if this is somehow related to bug #93749.
Comment 2 Alex Thurgood 2017-04-06 09:47:42 UTC
(In reply to Gerhard Schaber from comment #1)
> I am not sure, if this is somehow related to bug #93749.

Yes, quite possibly. Although the root cause is still unknown.
Comment 3 Alex Thurgood 2017-04-06 10:07:51 UTC
Marking as DUP of bug 93749, as it is reported as happening with a password protected macro library

*** This bug has been marked as a duplicate of bug 93749 ***