Forum Home
Press F1
 
Thread ID: 103949 2009-10-11 22:00:00 Any OpenOffice.org Users out there? Yorick (8120) Press F1
Post ID Timestamp Content User
819568 2009-12-07 03:09:00 At home and installed for many of my clients, very useful for those who need the foreign language dictionaries. It enables others to open Word 2007 Email attachments without having to outlay, to Microsoft, for something they otherwise do not need to update.
I also understand SeniorNet Wellington is running a few Open Office lessons over the New Year.
PENTIUM (426)
819569 2009-12-07 04:20:00 At home and installed for many of my clients, very useful for those who need the foreign language dictionaries. It enables others to open Word 2007 Email attachments without having to outlay, to Microsoft, for something they otherwise do not need to update.
I also understand SeniorNet Wellington is running a few Open Office lessons over the New Year.
That's good to hear, I've done presentations to various SeniorNet groups, the biggest barrier to uptake for them was the easy availability of Training materials like the "Made Easy" series on OOo. I steered them in the direction of Solvieg Haugland's Site (getopenoffice.org) and learnopenoffice.org (learnopenoffice.org)so hopefully it was useful to them and they got what they needed.
Yorick (8120)
819570 2009-12-07 07:17:00 I'm afraid I have to confess to being a Database dunce. I do know the biggest difference is that Access only uses one Database: MS Jet, whereas Base can use a number of SQL database backends such as MySQL, postgresql, Oracle and so on.
Hate to correct you here, but... Access can use almost any database backend, although it can sometimes be a tad annoying. Anything that has ODBC drivers (and that's almost anything) can be used from Access; among others we use Access for generating reports from several Oracle databases at work.

That said... Any improvements to Base are extremely welcome. Access annoys the hell outta me!
Erayd (23)
819571 2009-12-07 15:21:00 Hate to correct you here, but... Access can use almost any database backend, although it can sometimes be a tad annoying. Anything that has ODBC drivers (and that's almost anything) can be used from Access; among others we use Access for generating reports from several Oracle databases at work.

That said... Any improvements to Base are extremely welcome. Access annoys the hell outta me!

Heh Correct away, I did say I was a database dunce just didn't realise I was going to prove it so quickly. :D

It makes it a good day, because I've learned something new. :)

Does it do stuff with JDBC drivers?
Yorick (8120)
819572 2009-12-07 18:30:00 Does it do stuff with JDBC drivers?
Not that I'm aware of - I can't categorically rule it out, but I'd be extremely surprised if it natively spoke JDBC. You could probably do it with an ODBC-JDBC bridge though.
Erayd (23)
819573 2009-12-08 05:42:00 My own personal use however has been limited by the inability to use 'action queries' in Base as opposed to the easy use in MSAccess - I do heaps in Access, but would dearly love to migrate forever to Linux and OOo.
For me to migrate, I need an easier path towards coding macros and action queries in Base. The MSAccess equivalents being queries that can Update / Delete / Append / MakeTable being my key requirements.

Probably the best bet is to chat to the Base developers. There is a users mailing list that you can subscribe to by sending a blank email to:
users-subscribe@dba.openoffice.org

There are some documentation links here in the OOo Wiki (wiki.services.openoffice.org) and an article on connecting to an Access DB (wiki.services.openoffice.org)

These guys are way more qualified than me to make suggestions. Often it's a matter of different "terms" for the same functionality, they would know the equivalences better than this demonstrable dunce. ;)
Yorick (8120)
819574 2009-12-08 06:34:00 Not that I'm aware of - I can't categorically rule it out, but I'd be extremely surprised if it natively spoke JDBC. You could probably do it with an ODBC-JDBC bridge though.

I did a bit research and while there is lots of info with regard to connecting to Access via a JDBC-ODBC bridge, nothing I can find for the other way round. This probably just means however that I'm fishing in waters too murky for me to read. :groan:
Yorick (8120)
819575 2009-12-08 07:23:00 Probably the best bet is to chat to the Base developers. There is a users mailing list that you can subscribe to by sending a blank email to:
users-subscribe@dba.openoffice.org

There are some documentation links here in the OOo Wiki (wiki.services.openoffice.org) and an article on connecting to an Access DB (wiki.services.openoffice.org)

These guys are way more qualified than me to make suggestions. Often it's a matter of different "terms" for the same functionality, they would know the equivalences better than this demonstrable dunce. ;)

So therefore why not wait to solve an Open office problem a PressF1 user comes up with?
Sweep (90)
819576 2009-12-08 10:55:00 So therefore why not wait to solve an Open office problem a PressF1 user comes up with?

Sorry Sweep I'm not sure I understand the question...
Yorick (8120)
819577 2009-12-08 18:45:00 Let me try to make it more clear.

Rather than telling the general population of PressF1 about all the advantages of Open Office why not wait until a user comes up with "How do I do xyz with Open Office?"

Then would be the best time to jump in with the help I think.
Sweep (90)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17