OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Need Help with Base - how it saves etc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
IanW
General User
General User


Joined: 09 May 2007
Posts: 15
Location: South Africa

PostPosted: Tue Oct 26, 2010 7:38 am    Post subject: Need Help with Base - how it saves etc Reply with quote

Hi All
Am looking for some help with Base from an expert....

I'm running OOBase 3.2 on Kubuntu 10.04.

I designed a Membership DB some time back that works fine BUT I do get a lot of Power Cuts here and have the following problems...

1) Base does NOT seem to 'Save Record on Exit' which is what I'm used to from all DB Software I've used in the past. Is this correct?

2) The only way to save is to exit the Form Layout and then close the whole program down. BUT the first step takes about 1min to close and the second step about 5 to 10mins to close!!!! Why does it take so long to do this?? When I re-start after a Power Cut I get the 'Recovery Window' but this also does not recover any of the info I have put in since the last full shutdown. ?????? Other software I use, including OOWrite and OOCalc etc do not show this problem!

I have about 2000 records (about 50% fully populated) with approx 70 fields and two photos in each record. Not exactly "Heavy Duty"!!! I have lost so much info because of this and frequently have to re-enter data again!! I have to crack this one as it makes the system totally unreliable!!

It has been suggested that I change the DB Engine . Will this help and if so to what and how?

Last of all I have installed the new LibreOffice software but can not get the LOBase to 'see' my Database. How can I do this to test it in the new software?

Thanks for any help
_________________
Ian Whitfield
Pretoria
South Africa
Back to top
View user's profile Send private message Visit poster's website
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Tue Oct 26, 2010 7:55 am    Post subject: Reply with quote

Hello

In the sql tool

with checkpoint defrag

Read also this

Romke
Back to top
View user's profile Send private message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Tue Oct 26, 2010 8:00 am    Post subject: Reply with quote

If you search the archive, you will find at least one discussion... that one was a while ago... about a macro to flush your RAM to your hard drive each time you exited an edited record.

Ah! Since writing the above... found it...

http://www.oooforum.org/forum/viewtopic.phtml?t=58231&highlight=flush+macro

As it was a while ago... maybe the need for the sort of flush it did is no longer relevant....

Sorry!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group