Page 1 of 3 123 LastLast
Results 1 to 10 of 28

Thread: Looking for something like MS Access

  1. #1

    Default Looking for something like MS Access

    I am looking for an application that allows quick, easy, end user friendly access to a relational database. I need to be able to define forms for data entry and editing and produce reports. It really needs to be cross platform Linux and Windows and not expensive (free). It must be usable by people with very little IT experience. I can set the application up including the forms and reports but I want to be able to transfer it to others.

    The database is not important as long as it supports RI, identity columns or something that passes for identity columns and probably triggers. This is a single user system. There should be a version in French and it should not get upset by characters such as , etc.

    I had a look at openoffice base. It does not rate very highly on my list of user friendly applications.

    Any ideas?

  2. #2
    Join Date
    Aug 2008
    Location
    Seattle, WA
    Posts
    1,376

    Default Re: Looking for something like MS Access

    What does Access have that OpenOffice is missing?

  3. #3
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Looking for something like MS Access

    On 2011-02-10 22:36, vindevienne wrote:
    >
    > I am looking for an application that allows quick, easy, end user
    > friendly access to a relational database. I need to be able to define



    I asked a very similar question some months back.

    "is Kexi supposed to be able to use an existing mysql database?" in this
    subforum, and "What database frontend to use?" in the "looking for" subforum.

    Have a look at the answers to both, please. I'm also interested in new
    answers here, obviously :-)

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  4. #4
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Looking for something like MS Access

    On 2011-02-10 23:36, chief sealth wrote:
    >
    > What does Access have that OpenOffice is missing?


    A lot!

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

  5. #5
    Join Date
    Jun 2008
    Location
    Earth - Denmark
    Posts
    10,730

    Default Re: Looking for something like MS Access

    On 02/10/2011 11:36 PM, chief sealth wrote:
    >
    > What does Access have that OpenOffice is missing?


    simple useability

    --
    DenverD
    CAVEAT: http://is.gd/bpoMD
    [NNTP posted w/openSUSE 11.3, KDE4.5.5, Thunderbird3.0.11, nVidia
    173.14.28 3D, Athlon 64 3000+]
    "It is far easier to read, understand and follow the instructions than
    to undo the problems caused by not." DD 23 Jan 11

  6. #6
    Join Date
    Oct 2008
    Location
    North Wales, UK
    Posts
    1,114

    Default Re: Looking for something like MS Access

    The trouble is that only a minority of people know enough about a database to install and run access or use it. (Besides the extra licensing cost for M$ Office Pro!)
    Until there is a need or more users require it, OpenOffice Base doesn't have either the client side server connectivity (ODBC to M$sql or Oracle servers, say) or power and ease of use that Access has.
    Let's face it, to the normal user, a decent wordprocessor and spreadsheet is all thay want.
    Sad but true, but at the end of the day, OOO is free!
    http://catb.org/~esr/faqs/smart-questions.html
    (How to ask questions)

  7. #7
    Join Date
    Aug 2008
    Location
    Seattle, WA
    Posts
    1,376

    Default Re: Looking for something like MS Access

    Quote Originally Posted by robin_listas View Post
    > What does Access have that OpenOffice is missing?

    A lot!
    Just wondering. Knowing why the OP won't consider OOo would narrow the field considerably.

  8. #8
    Will Honea NNTP User

    Default Re: Looking for something like MS Access

    whych wrote:

    >
    > The trouble is that only a minority of people know enough about a
    > database to install and run access or use it. (Besides the extra
    > licensing cost for M$ Office Pro!)
    > Until there is a need or more users require it, OpenOffice Base doesn't
    > have either the client side server connectivity (ODBC to M$sql or Oracle
    > servers, say) or power and ease of use that Access has.
    > Let's face it, to the normal user, a decent wordprocessor and
    > spreadsheet is all thay want.
    > Sad but true, but at the end of the day, OOO is free!


    I use OO with DB2 - mainly because I'm familar with DB2 - via either ODBC or
    JDBC drivers but to the end user at the office, it's just a spread sheet and
    I do pretty much all the SQL side to set up those "pretty" reports. A
    couple of the gals are pretty good with spreadsheets but completely in the
    dark about actual RMBS database usage. I have to agree that using OO
    effectively with databases is not for the faint of heart if you get beyond
    the very simple basics.

    Besides, the last few releases of OO Base has been really buggy for me -
    crashes are the order of the day when trying to set up connections.

    --
    Will Honea

  9. #9
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,454

    Default Re: Looking for something like MS Access

    There is no simple answer to the original question because Access incorporates many of the features which programs like mysqladmin add to mysql. However, its inbuilt security options are more limited than in mysql and, natively, it uses a non-standard database file system. It can however be used as a front end for an SQL database, whether MSSQL or mysql, though some administration still needs to be done via SQL scripts rather than by using Access.

    Kexi is not a direct replacement for Access as it does not have the range of features that Access does.

    The other limitation of Access is that does not play well with web interfaces, having been designed before the Internet became widely available. So my long term advice would be to consider moving away from Access to an SQL database and a front end that is equally comfortable with traditional office environments and web interfaces.

  10. #10
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: Looking for something like MS Access

    On 2011-02-11 10:06, john hudson wrote:

    > So my long term advice would be to consider moving away from
    > Access to an SQL database and a front end that is equally comfortable
    > with traditional office environments and web interfaces.


    Obviously. But what frontend would you use, that is similar to MS A in
    usability? That's the big problem in Linux.

    OO is short of the mark. Many require programing or sql or whatever. MS A
    is graphical an intuitive, mostly.

    --
    Cheers / Saludos,

    Carlos E. R.
    (from 11.2 x86_64 "Emerald" at Telcontar)

Page 1 of 3 123 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •