[clug-talk] Help: OpenOffice Base - SOLVED (I guess)
TekBudda at shaw.ca
Thu Aug 16 22:38:01 PDT 2007
Well spank my arse and call Aunt Matilda....that freakin worked! The only
thing I don't particularly like about that process is that you need to
create a spreadsheet before you can create the tables and you have to
include a primary key. If you remove the primary key afterwards, you end up
losing the ability to enter data....It also looks like if you open the new
db...and create a new table, as long as you are including a primary key for
that table you are ok.
I know Pkeys are necessary but makes it a bit of a pain for someone that may
have never worked with pkey's before.
Thanks for the Help Neil....not a perfect solution (for me anyways...and we
all know how different I am) but it works.
From: clug-talk-bounces at clug.ca [mailto:clug-talk-bounces at clug.ca] On Behalf
Of Neil Bower
Sent: August 16, 2007 10:54 PM
To: clug-talk at clug.ca
Subject: Re: [clug-talk] Help: OpenOffice Base
I came across this and thought it may be helpful.
Hope it helps.
On Thursday 16 August 2007 14:06, TekBudda wrote:
> I don't know if I am just mental or what, but I am running into a problem
> and can't seem to figure out a solution.
> Normally when I start designing a database I will create it in a
> so I can play with the columns and such, before put the data into a
> But in the before time (Mad Max reference to the olden days ;-D) when I
> using MS Access more religiously I would go in, create a table then go
> a table view and begin entering data and worry about forms and such later.
> Well...I figured I would try to do the same thing with OOoBase. So I
> created a table in the native *.odb format and was all set to start
> information. BUT...I went to open the table and no way to enter records.
> SO then I thought create a form...BUT every attempt (so far) has had the
> form in read-only or has crashed and caused an error. I thought part of
> problem could have been it being on a USB key, but I moved it from there
> the home folder adn the same thing. I seemed to be getting the same
> behaviour on WinXP and Ubuntu 7.04 using a fairly recent version of OOo.
> Can anybody shed some light.. or maybe slap me with a stick and get me on
> the right track? It just seems very counterintuitive at this for
> recommending OOo fully (at least the database portion) as a full drop-in
> replacement for MS Office.
> clug-talk mailing list
> clug-talk at clug.ca
> Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
> **Please remove these lines when replying
clug-talk mailing list
clug-talk at clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
More information about the clug-talk