dbTalk Databases Forums  

Comparison of OpenOffice Base to Microsoft Access ?

comp.databases comp.databases


Discuss Comparison of OpenOffice Base to Microsoft Access ? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
croy
 
Posts: n/a

Default Comparison of OpenOffice Base to Microsoft Access ? - 10-05-2010 , 10:53 AM






I'd love to hear about the experiences of those who have
used both OpenOffice Base and Microsoft Access.

I'm somewhat familiar with MS Access, but have never tried
Base.

For an MS Access user, is there any chance of warming up to
Base?

The reason for my interest is the limited / expensive
availability of MS Access.

--
Any thoughts appreciated.

croy

Reply With Quote
  #2  
Old   
Ben Finney
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 10-05-2010 , 04:12 PM






croy <croy (AT) invalid (DOT) net> writes:

Quote:
I'm somewhat familiar with MS Access, but have never tried
Base.
My experience with the two is limited to several years ago, teaching a
former MS Access user.

Quote:
For an MS Access user, is there any chance of warming up to
Base?
Yes, they are very similar overall; the Base user interface seems
deliberately modelled to be familiar to MS Access users.

Quote:
The reason for my interest is the limited / expensive availability of
MS Access.
You'll also get the big advantage of working smoothly with free-software
and robust DBMSen.

Good hunting.

--
\ “The lift is being fixed for the day. During that time we |
`\ regret that you will be unbearable.” —hotel, Bucharest |
_o__) |
Ben Finney

Reply With Quote
  #3  
Old   
croy
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 10-06-2010 , 07:49 AM



On Wed, 06 Oct 2010 08:12:51 +1100, Ben Finney
<bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

Quote:
croy <croy (AT) invalid (DOT) net> writes:

I'm somewhat familiar with MS Access, but have never tried
Base.

My experience with the two is limited to several years ago, teaching a
former MS Access user.

For an MS Access user, is there any chance of warming up to
Base?

Yes, they are very similar overall; the Base user interface seems
deliberately modelled to be familiar to MS Access users.

The reason for my interest is the limited / expensive availability of
MS Access.

You'll also get the big advantage of working smoothly with free-software
and robust DBMSen.
Thanks Ben.

Does Base have any built-in ability to create stand-alone
applications?

--
croy

Reply With Quote
  #4  
Old   
Ben Finney
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 10-06-2010 , 04:39 PM



croy <croy (AT) invalid (DOT) net> writes:

Quote:
Does Base have any built-in ability to create stand-alone
applications?
I don't know, we didn't try that.

You might find more knowledgeable answers on the forums specifically for
OpenOffice.org Base discussions
<URL:http://dba.openoffice.org/servlets/ProjectMailingListList>.

--
\ “If we listen only to those who are like us, we will squander |
`\ the great opportunity before us: To live together peacefully in |
_o__) a world of unresolved differences.” —David Weinberger |
Ben Finney

Reply With Quote
  #5  
Old   
David Segall
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 11-22-2010 , 03:16 PM



David Segall <david (AT) address (DOT) invalid> wrote:

Quote:
Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:


You'll also get the big advantage of working smoothly with free-software
and robust DBMSen.


MS Access can be used with any database that has an ODBC driver just
as OpenOffice Base can be used with any database that has a JDBC
driver. The open source Firebird, Ingres and PostgreSQL RDBMSs all
provide ODBC drivers. Not even Microsoft recommend using the database
that comes with Access.

Reply With Quote
  #6  
Old   
David Segall
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 11-22-2010 , 03:16 PM



Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:


Quote:
You'll also get the big advantage of working smoothly with free-software
and robust DBMSen.

MS Access can be used with any database that has an ODBC driver just
as OpenOffice Base can be used with any database that has a JDBC
driver. The open source Firebird, Ingres and PostgreSQL RDBMSs all
provide ODBC drivers. Not even Microsoft recommend using the database
that comes with Access.

Reply With Quote
  #7  
Old   
Ben Finney
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 11-22-2010 , 05:35 PM



David Segall <david (AT) address (DOT) invalid> writes:

Quote:
Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

You'll also get the big advantage of working smoothly with
free-software and robust DBMSen.

MS Access can be used with any database that has an ODBC driver
[…]

ODBC is a far cry from “working smoothly with” the database server.

--
\ “The reward of energy, enterprise and thrift is taxes.” |
`\ —William Feather |
_o__) |
Ben Finney

Reply With Quote
  #8  
Old   
David Segall
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 11-30-2010 , 07:25 AM



David Segall <david (AT) address (DOT) invalid> wrote:

Quote:
Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

David Segall <david (AT) address (DOT) invalid> writes:

Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

You'll also get the big advantage of working smoothly with
free-software and robust DBMSen.

MS Access can be used with any database that has an ODBC driver
[]

ODBC is a far cry from working smoothly with the database server.
Why is ODBC significantly worse than JDBC?

Reply With Quote
  #9  
Old   
David Segall
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 11-30-2010 , 07:26 AM



Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

Quote:
David Segall <david (AT) address (DOT) invalid> writes:

Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

You'll also get the big advantage of working smoothly with
free-software and robust DBMSen.

MS Access can be used with any database that has an ODBC driver
[]

ODBC is a far cry from working smoothly with the database server.
Why is ODBC significantly worse than JDBC?

Reply With Quote
  #10  
Old   
Jasen Betts
 
Posts: n/a

Default Re: Comparison of OpenOffice Base to Microsoft Access ? - 12-02-2010 , 12:05 PM



On 2010-11-30, David Segall <david (AT) address (DOT) invalid> wrote:
Quote:
Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

David Segall <david (AT) address (DOT) invalid> writes:

Ben Finney <bignose+hates-spam (AT) benfinney (DOT) id.au> wrote:

You'll also get the big advantage of working smoothly with
free-software and robust DBMSen.

MS Access can be used with any database that has an ODBC driver

ODBC is a far cry from “working smoothly with” the database server.

Why is ODBC significantly worse than JDBC?
I don't think that claim was ever made, ODBC seems to be a one size
fits Microsoft solution.

I haven't looked at JDBC, hopefully it's not designed around
compatibility with a single vendor.

--
⚂⚃ 100% natural

--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.