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. Hank
On Sun, Jan 20, 2013 at 4:55 PM, Dan Lewis <elderdanle...@gmail.com> wrote: > On 01/20/2013 04:31 PM, Hank Alper wrote: > >> Hi >> 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 >> the >> 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, >> but >> the new Report and the modifications to a query I made in this session >> were >> gone. I think* most* of this behavior is due to Report Builder. Has anyone >> >> else observed this type of behavior before ?. >> Hank >> > 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. > > --Dan > > > -- > For unsubscribe instructions e-mail to: users+help@global.libreoffice.** > org <users%2bh...@global.libreoffice.org> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted