OS X Database software?

Discussion in 'Mac Apps and Mac App Store' started by anonymust, Jun 5, 2013.

  1. anonymust macrumors member

    anonymust

    Joined:
    Sep 20, 2010
    Location:
    in a house
    #1
    So uhm..... I spent like 2 weeks creating a well designed databse in MS Access (on a windows desktop)..

    And now I find out that MS Access isnt on OSX!

    How on earth do I now view, insert and edit my database on OS X?
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    You don't. Or you run Windows on your Mac.

    Microsoft Access on Mac
     
  3. rkaufmann87 macrumors 68000

    rkaufmann87

    Joined:
    Dec 17, 2009
    Location:
    Folsom, CA
    #3
    You will need to get a database designed for multiplatforms. I'd suggest using Filemaker Pro.
     
  4. Badrottie Suspended

    Badrottie

    Joined:
    May 8, 2011
    Location:
    Los Angeles
  5. macmikey macrumors newbie

    Joined:
    Nov 7, 2003
    Location:
    Texas
    #5
    There's always Oo.o

    A lot of people poo-poo OpenOffice.org's Base component, but it's the most Access-like database product available for the Mac. A couple of big issues make it a no-go for me (like absolutely NO macro-building as in Access), but it's worth a look.
     
  6. jrs22 macrumors 6502

    Joined:
    Aug 1, 2012
    #6
    Open Office and Libre Office are free so its easy enough to download them and test your database. When I tried opening some Access databases I ended up with nothing but queries.

    Also, Filemaker Pro may not do what you need as people often underestimate Access capabilities. I ended up buying Windows 8 to run Access on my mac.
     
  7. inkyfingers macrumors newbie

    Joined:
    Nov 23, 2010
    Location:
    Kent, UK
    #7
    Filemaker is the daddy of database programs, you can easily transfer the data from access to Filemaker using a .csv or .dbf file.
     
  8. scr1968 macrumors regular

    Joined:
    Sep 4, 2007
    #8
    FileMaker is the way to go for sure. You might also try this in conjunction with FileMaker..

    http://www.fmpromigrator.com

    SCR
     
  9. ssmed macrumors 6502

    ssmed

    Joined:
    Sep 28, 2009
    Location:
    UK
    #9
    Look at 4D if you want more power than FileMaker.

    www.4D.com

    HTH
     
  10. JoeRito macrumors 6502

    JoeRito

    Joined:
    Apr 12, 2012
    Location:
    New England, USA
    #10
    FileMaker is nice for designing applications around data, but its doesn't do what Access does. There is no real query design environment where you link tables to do advanced querying. You can filter data easily in FM, but you can't manipulate large tables using advanced queries like in Access or other DB's.

    When I switched to Mac I started using FM but found it woefully deficient for my needs. I crunch a lot of data and need a tool like Access. If you do too, I recommend virtualizing windows with Parallels and buying a copy of Access.
     
  11. ssmed, Jun 8, 2013
    Last edited: Jun 8, 2013

    ssmed macrumors 6502

    ssmed

    Joined:
    Sep 28, 2009
    Location:
    UK
    #11
    It would be useful to know more

    As mentioned by JoeRito, if your DB is for data crunching rather than for yourself to work with perhaps to derive some data for analysis or research then FileMaker is probably less useful than say 4D or mySQL for instance. However if you are looking to create a solution for repetitive data entry and report generation (e.g. Invoices, stock lists and form letters) then Fikemaker is very likely to fit the bill.

    Nearly all of the possibilities are available for trial periods at no cost.

    HTH

    SS
     
  12. anonymust thread starter macrumors member

    anonymust

    Joined:
    Sep 20, 2010
    Location:
    in a house
    #12
    Just tried OpenOffice... not a great alternative..... (Im too used to Access....)

    I think i will install Windows XP on a virtual machine and run it.
     
  13. jimthing macrumors 6502a

    jimthing

    Joined:
    Apr 6, 2011
    Location:
    London, UK
    #13
    WinXP is on the way out of support, so given it's mid-2013, most around here I'm sure would strongly suggest you bite the bullet and go Win8 or the very least Win7 as the VM. Longer usable lifespan, and Access shouldn't have any problem with either of Win7/8.
     
  14. Wando64 macrumors 6502

    Joined:
    Jul 11, 2013
    #14
    As far as I can see Oracle DB is available for OSX.
    How much more of a DB can anybody need?
     
  15. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #15
    There is a thing called too much power. Oracle databases are enterprise solutions, the OP is looking for a single user type database. I work on Oracle databases and I don't see it as a viable solution for a consumer looking for small database program.

    OP, the makers of FileMaker offer Bento a very simple database program, easier to use then FileMaker Pro (and less features) but it may be good enough.

    I agree there's no equal counterpart to MS Access.

    The other option is run Access within a Windows VM (such as Vmware Fusion or Parallels).
     
  16. SpinalTap macrumors regular

    SpinalTap

    Joined:
    Sep 25, 2003
    Location:
    Bournville, UK
    #16
    I run Access 2010 on my Mac Mini via CrossOver12.

    This program does not require installing any derivative of the the WindowsOS.

    You can download a free evaluation trial of CrossOver12 from Codeweavers.

    http://www.codeweavers.com

    Alternatively, you can install the freely available VirtualBox and then install your existing WindowsOS on top of that before then installing Access.

    https://www.virtualbox.org
     
  17. jschmidt1340 macrumors newbie

    Joined:
    Aug 25, 2010
    #17
    FYI, FileMaker just announced that they are ceasing support and sales of Bento. FileMaker Pro is the only product that they will be supporting going forward. If you still want to buy Bento, get it before they stop sales in September.
     
  18. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #18
    Shocking but I guess I really shouldn't be. It was very limited in features. I'm actually moving up to FP12 though I'm holding off on purchasing as I wonder if FileMaker Pro 13 is coming close to being released.
     

Share This Page