On Wednesday 15 November 2006 11:02 am, [EMAIL PROTECTED] wrote: > 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? > > Many thanks in anticipation. > > Kind regards, > > Howard Smith
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 > > -------------------------------------------------------------------- > mail2web - Check your email from the web at > http://mail2web.com/ . > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
