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. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Bower Sent: August 16, 2007 10:54 PM To: [email protected] Subject: Re: [clug-talk] Help: OpenOffice Base I came across this and thought it may be helpful. http://sheepdogguides.com/fdb/fdb1imp1.htm Hope it helps. Neil B. 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 spreadsheet > so I can play with the columns and such, before put the data into a databse. > But in the before time (Mad Max reference to the olden days ;-D) when I was > using MS Access more religiously I would go in, create a table then go into > 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 entering > 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 the > problem could have been it being on a USB key, but I moved it from there to > 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. > > Cameron > > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying > _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
