Results 1 to 10 of 10

Thread: Access-type database for Linux ?

  1. #1
    Join Date
    Jan 2009
    Location
    Belgium
    Posts
    245

    Default Access-type database for Linux ?

    Hi,

    I'm fairly new to Linux and I am looking for an Access-like DBMS for Linux. I'm an experienced VBA-programmer and SQL-user. Is there something like Access around?

    I'll use it with large databases : 1 to 2 GB.

    Thanks for your hints and tips.

    I already thought MySQL could help me, but I do not know how to get it, nor to install it.

    W

  2. #2
    Join Date
    Jun 2008
    Location
    /dev/swat
    Posts
    1,181

    Default Re: Access-type database for Linux ?

    You can use openOffice base, which is alternative for M$ Access.
    Base
    You can install it from yast->software management and search for this keyword: openoffice_org-base

    About Mysql, you can also install it from yast->software management and search for mysql.
    You can use then mysql query browser and mysql administrator to administrate the databases.
    type in search in yast ->software management:
    mysql-query-browser
    mysql-administrator

    Hope, this will help.
    Linux[openSUSE, KDE], PHP, MySQL, Wordpress, Tech News, etc :
    http://anl4u.com

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

    Default Re: Access-type database for Linux ?

    Strictly speaking there is no equivalent to Access in any other OS. Access does two things, manages your access to data and allows you to create views on your data. Unfortunately, its access controls are limited; for example, you cannot create a table view in which certain columns are not accessible to the user.

    There is a project, Kexi, which is attempting to provide similar features but development appears to have stalled.

    A lot depends on what you use Access for. If it is simply a frontend for your data, then OOo Base will do fine but you will need to set your data up in mysql separately before using Base for anything but the most limited tasks - in which case using OOo Base without mysql would be better.

    If you are doing anything more complicated, you need to set your data up in mysql and then either use one of the mysql tools or develop your own frontend separately.

    Note that Access can to set up to access mysql tables so it is practical to use Access from a Windows environment and another frontend from a Linux environment.

    If you want to transfer everything to Linux, you need to export to csv either via Excel if the tables are not too large or one of the Access tools.

  4. #4

    Default Re: Access-type database for Linux ?

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    There are also a lot of Access2MySQL type converters that will do the
    export of data from JET to MySQL via SQL statements. I helped a business
    port their environment from an access DB backend (a website was based on
    the database) to MySQL and queries that used to take thirty to forty
    seconds (made the web users REALLY happy to wait that long) sped up to the
    point that they couldn't even time them properly (same machine, even left
    windows on the box at the time (six years ago), and ran the two web
    servers side by side). Anyway, it was a great way for me to really
    experience how slow the database side was. For gigabytes of data I can't
    even imagine using something besides a real DBMS like Access or
    PostgreSQL. For something that doesn't run a full-time engine there are
    options like SQLite as well though, again, for a big database it's worth
    going with an engine.

    Install MySQL: http://en.opensuse.org/MySQL

    Once done find the interface you prefer (command-line, GUI, etc.). A tool
    I use a lot (because it is free and works on all platforms for all
    JDBC-enabled databases) is DB Visualizer:
    http://www.minq.se/products/dbvis/ The for-pay version is probably worth
    it but I'm not a DBA full time so this works well enough for me and runs
    beautifully on Linux. It's not made for any one DB so as long as you are
    not tied to one particular setup you'll be fine, and if you are tied to
    one you'll learn the DB-agnostic way which will help with everything else
    in life.

    Anyway give it a shot. The amount of data online about MySQL is insane
    and you shouldn't have much trouble getting it working. If you're doing
    websites also investigate phpMyAdmin as it is a great tool for web-based
    administration of your database.

    Good luck.





    john hudson wrote:
    > Strictly speaking there is no equivalent to Access in any other OS.
    > Access does two things, manages your access to data and allows you to
    > create views on your data. Unfortunately, its access controls are
    > limited; for example, you cannot create a table view in which certain
    > columns are not accessible to the user.
    >
    > There is a project, Kexi, which is attempting to provide similar
    > features but development appears to have stalled.
    >
    > A lot depends on what you use Access for. If it is simply a frontend
    > for your data, then OOo Base will do fine but you will need to set your
    > data up in mysql separately before using Base for anything but the most
    > limited tasks - in which case using OOo Base without mysql would be
    > better.
    >
    > If you are doing anything more complicated, you need to set your data
    > up in mysql and then either use one of the mysql tools or develop your
    > own frontend separately.
    >
    > Note that Access can to set up to access mysql tables so it is
    > practical to use Access from a Windows environment and another frontend
    > from a Linux environment.
    >
    > If you want to transfer everything to Linux, you need to export to csv
    > either via Excel if the tables are not too large or one of the Access
    > tools.
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.9 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJKhrVCAAoJEF+XTK08PnB5XTgQANWz4JTvIOYNw0e7mlx6CZIn
    XqBZXsSp2y+YMTzvygUIk5sTpQthkygqC3VI/OFKhPxTFl8VXwdWx8QHw0bQCTb2
    01AaE9X/utQuNdG8RT1tKtIqPUbtAjCkZsOvY2EZ3wkhe2e1g+LeyNFupNsbsDjw
    bPIOQ6wsECPJSsIPx2w2dVH2MZB05BBESJ5y1VUeGqjEnUBY3FJpB6j3pwSlbnEN
    X3l2kVJ8r+aSalnODsnjgBrWMkW+sieq+T4P46tFyihGt4au34waYEvm16LjU30u
    A+r2Qff/mkhLIZM7PadZIsGpikB5ylJMFFVaoZAscG+zJzYMmgwpLtLWmdt51nDY
    5hVhmaK5y1DuS6rSTVArd8oSmqvB0zr5/qaQLSK9RL5eIgPvak2TOl1lURKAcLUf
    lIeFLTRewlpMD+A+quBfJAI/f+36hnGuA3jtbYPai86IzshQ6sBqYprlje5lsQS2
    ZNIM7pZ1s9NaGawWM5xtHz5hQMDIsAttwncyaXX4GtSp52/+M7cO47hlj4kLuNnp
    JeP62wCgNoCAAqjn4a63Wj30L0XXard2Z95Uv27ZNSby3qUihVjaDNecVw4N8U4v
    8qlbAkDFoXx9p+wrDQCwd0ENzCSCqLVCRCKuKv7LDctH5teVTcWPWoAnMUYKOjQM
    /os/2Evz8DKt6/SX8Dy6
    =DUK7
    -----END PGP SIGNATURE-----

  5. #5
    Join Date
    Jan 2009
    Location
    Belgium
    Posts
    245

    Default Re: Access-type database for Linux ?

    Thanks to all of you for your fast responses.

    I'll try and if I stillhave problems, I'll come back to this forum.

    W

  6. #6
    Dave Parkes NNTP User

    Default Re: Access-type database for Linux ?

    To ab@novell.com

    >For gigabytes of data I can't
    >even imagine using something besides a real DBMS like Access


    Can I quote you on that ? <g>

    Cheers Dave


    --
    Dave Parkes [NSCS]
    Occasionally resident at http://support-forums.novell.com/

  7. #7

    Default Re: Access-type database for Linux ?

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Sure. Access is poo, but like everything microsoft puts out it's
    point/click which is its only positive quality. Bringing database
    functionality to the masses is a fine idea, but don't do it for systems
    that matter or are made to be on servers. Access has been used to bridge
    that gap, and it shouldn't be.

    Good luck.





    Dave Parkes wrote:
    > To ab@novell.com
    >
    >> For gigabytes of data I can't
    >> even imagine using something besides a real DBMS like Access

    >
    > Can I quote you on that ? <g>
    >
    > Cheers Dave
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.9 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJKiXdpAAoJEF+XTK08PnB5alAQALLS8RX0DUd6LniyYP+p8lPN
    h+kLrH+Tyn+dIgEaPqAUImpG5fdUtDQUmlWaGeSBf/0AIddC9sTHLe3okf5xxw7X
    I4KXwgnAanUDx8vZYxImbU2Z7AR+i9A1ondO5vQQ9kDLACkNIUfGGhvpQs16bOk6
    7+bRU75o/IlEMblJdJS7V0NS/J0YMW6cUBVMxA4W0VQG4oXN570nDrB6NLTMr6aH
    Hm9VjO6ZaX5SXOenRm48jk/pI00K4aWIH72o1ebuU2HAizYEa6Z+gOXZ9eBipWrf
    ciY2I/5cHhgRnwL8puMV3VSDXXtDJohk5Rc1mGbzpNKcyjf+dGlnU/BFeFp0qrEz
    UE3You2Gl7oWoWSENeaTy0vW/lXI/o6r3KckEOU46ItZE2/UeBx9+htI5BTDxwB4
    QNPSQ1MtexovugwzdtCFnCbMa240C9dyz1riXgdRN7upnQZdVKVHX34kfi5dIMzR
    qRLRy9G8IoNYgjQNnI+m6AUMs//EkJGcn6juDIu/bSx/UhEc+FbAPojK3eBtiR0Y
    nW+3leU+H7pQM1ajEASO+oBut/0sGX03sK8F9Ld89/6UJ7fcO2yrzXMWDK77cKKG
    J9j1biECb7IL2i6L1luLkj1J/SW9mZ2oFrlO6El2NQQwEQazVSUkfFmCegFbKK2t
    f4rTZg9w7YoiS72p3H3h
    =4Cv5
    -----END PGP SIGNATURE-----

  8. #8
    Dave Parkes NNTP User

    Default Re: Access-type database for Linux ?

    <g>, it was the 'for gigabytes of data, use Access' recommendation that
    puzzled me

    Cheers Dave


    --
    Dave Parkes [NSCS]
    Occasionally resident at http://support-forums.novell.com/

  9. #9

    Default Re: Access-type database for Linux ?

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    Doh! I'm an idiot. I was thinking MySQL at the time. Sorry for any
    confusion... pretty funny about that though.

    Good luck.





    Dave Parkes wrote:
    > <g>, it was the 'for gigabytes of data, use Access' recommendation that
    > puzzled me
    >
    > Cheers Dave
    >
    >

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v2.0.9 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

    iQIcBAEBAgAGBQJKiYJQAAoJEF+XTK08PnB5lJsP/jh69oIEecvWrtxnm+cp0Alj
    qJ2ZdTc3oQlvqMngLtjHzxhGKkhQWe41cXTjxLTNOBAlruo30mRhof3PLF4/aNbv
    KS5OhUMtM1XTUt7IzdkOmnug7ctkeuqyZfyxT5W631Du7pT7Aux+Xycuhjz9EnqD
    Yi1MVOv9TQcQv760NidQ0qyKKwtl1N68QCSlvGq8s1KTqZ0r1zV+g7r/aOGXLl56
    qLYHVRXGwrgbMrUY1QNgF6ieJ6ib5a1CyDJ69ICaiiWOHqTJr9T1V2k1jF0c3rfw
    fpGslIpLYgClT0gdTPsoWqqYYMMT8XXALJ5PgdF1keP16kgDoWdYRdFoEzDMSr1m
    MHKK9ZSWg8U9wGcIwc+Pyn0DvG51NTsZfrlb1UZGNaqGrStUQxr652IZS1cnflpC
    2KvN8dROUyJLZfuIeiA4yL9VeMTfZd/jXyIABnpFwS3L8qFfpOymaJI6tl1u6aL7
    22BX7jxkNmmOqOrswmV4CMfwg3xaEF+v0GzXyeeSwjaJd1pmHfYYYV8dLYBv44pA
    gvT9DZ/EJm27zkv11TP6iHrxPI5s9IqrL1NjyZ5Hx46AND0VunxA+159dTJKkqOq
    k7OddCc9n53HKx6t1cyKLZxwsvFxQZTOXse3LIKfXZBkKdyLnhIZVQbEyIFJZe7C
    Gwl42ShjSX0IDy6nvcP7
    =qsuG
    -----END PGP SIGNATURE-----

  10. #10
    Dave Parkes NNTP User

    Default Re: Access-type database for Linux ?

    To ab@novell.com

    >pretty funny about that though.


    Made me smile :-)

    Cheers Dave


    --
    Dave Parkes [NSCS]
    Occasionally resident at http://support-forums.novell.com/

Posting Permissions

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