Hi :) Is this a 1st attempt at moving away from Windows and MS Office at the same time?
If the database was an Access database then the Queries, Forms and Reports don't translate easily and need to be re-created. The data in the Tables should be Ok and any relationships between the tables is likely to be ok (i would check that). You might be able to translate the Queries by going back into Access and view them as Sql statements and then copy&paste those into notepad and from there into Base. Access's Sql is quirky so it might be better to just re-create the Queries from scratch. Moving away from Windows does kinda force you into leaving MS Office but it's often a good idea to stay in Windows a bit longer and just get used to the programs first before migrating. LibreOffice is a crucial part of that, along with Firefox/Opera/Chrome instead of IE and Thunderbird/Evolution/Claws for emailing. A lot of programs written for Windows do work in Gnu&Linux using Wine (Wine Is Not an Emulator (it uses a more sophisticated approach)) but MS Office, Outlook (and Outlook Express) and Internet Explorer are 3 that don't work well. Rgards from Tom :) --- On Wed, 5/10/11, planas <[email protected]> wrote: From: planas <[email protected]> Subject: Re: [libreoffice-users] data base program To: [email protected] Date: Wednesday, 5 October, 2011, 15:11 Chaim, On Wed, 2011-10-05 at 13:57 +0200, Chaim Seymour wrote: > Hi all > > I set up Fedora 15 on my second computer and the Libre Office is included. > > As a fountain pen collector, I started building a database for my > collection. I defined the fields and built a table. I started filling the > table, but wanted to add an extra field. To my surprise, the structure of > the db had disappeared. The table works. I can add items and alphabetize. > > Can one go back and rebuild the db structure from the table and if so how > does one do it? > Right click on the table and select edit and you will see the table design. Make your changes, adding new columns should not cause any problems with data integrity and save. When open the database for data entry you will see the new column. > Thanks > > Chaim > > -- > Chaim Seymour > David Elazar 8 > Givat Shemuel 54032 > Israel > tel: 972-3-5320560 > -- Jay Lozier [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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
