Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi Dan,
Thanks for your quick response. I"m using LO version3.6.4.3 Build ID
:2ef5aff on a Windows 7 Pro machine. My machine's processor is an Intel
i7-2600K with 8Gig of memory and 1TB hard drive. I use periodic  backups to
another machine on my network. As for  AutoRecovery,  whenever there is a
catastrophic failure Base auitomatically tries to recover my database file
on the next start-up. Is that what you're referring to.? If not, I was
unaware that Base has such a feature.Is it similar to that used In MS Word?
 As for CHECKPOINT, I have not used that SQL command. When would it be
appropriate to use it? As for CHECKPOINT DEFRAG, when should that be used.
That might be useful as Base is getting much less responsive, seems
bloated.. The size of my database file is about 360 KB.

On Sun, Jan 20, 2013 at 4:55 PM, Dan Lewis <> wrote:

On 01/20/2013 04:31 PM, Hank Alper wrote:

I've invested a considerable amount of time in constructing tables, forms
and queries for a project of mine. I successfully produced 3 nice reports
using Report Builder. Now, I'm starting to observe strange behavior in
Base. Queries and Reports I've prepared days earlier suddenly disappear
after I've used them in Report Builder to prepare or edit a Report. As an
example, I've just used Report Builder to design a report, saved my work
and closed the file. I then ran the report in the viewer and it was fine,
but needed minor tweaking.I closed the viewer and then right clicked on
icon for my report in order to continue editing. LO closed down! When I
restarted, LO blithely announced it was recovering my database. It did,
the new Report and the modifications to a query I made in this session
gone. I think* most* of this behavior is due to Report Builder. Has anyone

else observed this type of behavior before ?.

     We need some basic information. What version of LibreOffice are you
using? What operating system do you use? Do you use backups or
AutoRecovery? Have you ever used CHECKPOINT as a SOL command? It closes the
database files, rewrites the script file, deletes the log file and opens
the database. If CHECKPOINT DEFRAG is specified, this command also shrinks
the .data file to its minimal size.


For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org <>
Posting guidelines + more: http://wiki.****
Netiquette <>
List archive: 
All messages sent to this list will be publicly archived and cannot be

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.