Hi Fred,
Many thanks for your response. Apologies too for the delay in
responding. I first saw your reply when I googled MS Access for u3!
Unfortunately I am unable to answer your queries at the moment as I am
away from my main computer, working on a laptop on which I cannot open
any Access files. All I can tell you is that I believe that the existing
data is formatted in whatever way Access defaults it to. I have been
able to make a decent connection now from OOo to the database and gain
write access but it would seem that the possibility of drawing this back
to the original Access file is not good. I'm not familiar with mysql
either but would obviously try to learn it if it could overcome this
problem.
Kind regards,
Howard
CPHennessy wrote:
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 users@openoffice.org only.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
