Open Office Database file (Help Please)?

Question

OK so this might sound confusing but i will explain it the best i can. Me an My boss share files, on here computer she has a Microsoft database and on mine i have a Open Office database. She put her database in the shared folder so i could Access hers from my computer. But Open Office wont let me view hers can someone help me please we have been trying to figure it out for days!

Answer 1

You have to copy the file and save it as an open office database. Then you can access your copy of the data base.



However, if this is not for you to read only, then when you change it, she would have to copy it and save it as a Microsoft database. It would be simpler to just to install a copy of her Microsoft data base program. Then both of you can use the data base without the constant copying and saving.



Outside of that, you will have to set it up on a server hard drive. And that should be done by a sys. op. Your boss would need to take some training.

Answer 2

I have found that most users forget to create a database to get started. If this is the case create one, if not I apologize.



This process depends on the application that the data was created in: Access, another database, an email program if you're exporting your address book, etc. Look under the File or Tools menu for an Export option. If you can export to a spreadsheet, do so; otherwise, exporting to a CSV or TXT file is fine.



If you don't have a database, you need to create one. Choose File > New > Database. Choose to create a new database and click Next.

This is the simplest part. Open your spreadsheet, and paste it into your new database. This part is for the user of open office because as you stated you are receiving the source file.



You heard me -- that's all there is to it. Well, there's a little more, but it's very easy. When you paste, you'll create a new table with the pasted data.



Note that you can append to an existing table or create a new table



Once you've got the data in, you can edit it normally.

Answer 3

I would need a little more information. Is your boss using Access, FoxPro or MSOfficeSuite. OpenOffice is equivalent to MSOfficeSuitePro -- they both are programmable.



Below is a link for Access connectivity. The results, if successful, would allow you database functions.



Maybe you only want to edit entries? Then do what the other answer told you about exporting the boss' database into a comma-deliniated file and you open in a spreadsheet. In fact, a spreadsheet can easily accomplish 20,000 entries and handshake better with word-processors.



Database is not intuitive, interactive or trivial.

Answer 4

You need to make sure you have saved the file as a DBX file. Then it will open in Access.