On Wed November 15 2006 16:02, + [EMAIL PROTECTED] wrote: > [ MODERATED ] *********************** > Hello, I wonder if you can help me. > > I have today downloaded and installed OpenOffice.org onto my u3 enabled > flash drive. My objective is to be able to save my MS Access database onto > the flash drive from my desktop pc and work with it on my laptop which > doesn't have MS Access installed on it. > > I have been able to open the database in OpenOffice but I cannot edit / > overwrite or add new information to it. The Filter buttons are active, as > are the A-Z sort facilities but all other editing buttons are greyed out. I > can select data fields but cannot type into them. There are, of course, a > few cosmetic differences between the OpenOffice interface and MS Access but > I'm not too bothered by that. What I would like to be able to do is the > following: > > 1 Edit and save work on the database > > 2 Enable the email address and website url hyperlinks in the database > > 3 Export the updated data back to Access in order to overwrite and update > the database when it returns to the hard drive on my desktop pc. > > Is this something you can help with?
As you are not subscribed you may not have seen that: On Thu November 16 2006 01:21, Fred Moore wrote: > > I will give this a shot. First off nothing in the world is compatable with > access. It is a very poor excuse for a rdb system. But to help I need to > know what format access has the db stored in? This info may help you in > editing and reading the db, standard CRUD stuff. > You will not be successfull in putting stuff back in the data base and then > having access use it. unless you are using a real db engine, not the MS > jet engine. Been there before. Do you have any options like mysql or > another real db engine you can put the data in and then use OO forms to > modify the data, and then use access to do the same. In reality this is > the only way this is going to work. .. Fred > Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
