MS Access

Discussion in 'Web Design and Development' started by raymondu999, Nov 6, 2008.

  1. raymondu999 macrumors 65816

    Joined:
    Feb 11, 2008
    #1
    Hi all. I'm taking a course in Information Systems Management, which requires me some programming and also web programming. Now I'm doing a JSP project, and I'm working out a login, but the rest of my project group is using Access, and despite my pleas they wouldn't switch to MySQL. So now I have to look for a way to interface with Access databases (and actually work on them) from Mac OS X. Is there a way to do this? I've readied myself by loading my license of VMware Fusion onto my machine, but I'd like to keep Windows as a last resort, if possible.:( Thanks.
     
  2. angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #2
    OpenOffice Base can do some database stuff. I tried using it to follow some MS Access course book examples and could do most of it, but if it goes to any level of complexity you'll run into issues. Some of the simpler stuff too has different naming schemes and tools are in different spots so can be frustrating following examples. I haven't found any easy ways to access the MS Access databases on Mac, or even hard ways for that matter. For some reason, schools don't seem to be catching on to the greatness of open source. Though sadly, there's a lot of jobs that want you to have MS software-specific skills.
     
  3. memco macrumors 6502

    Joined:
    May 1, 2008
    #3
    I think VMware is probably your simplest route. There is no Access for Mac so you'll have to run the Windows version somehow. Anyone know if Crossover can run it?
     
  4. SrWebDeveloper macrumors 68000

    SrWebDeveloper

    Joined:
    Dec 7, 2007
    Location:
    Alexandria, VA, USA
    #4
    Well said, I could not agree more. It makes me mad, actually.

    To the OP:
    If you got 2GB or more of RAM in your Mac, you can run VMWare or Parellels (I use that, love it) and a cheap OEM version of XP Home and it works great. Just install a free virus checker, don't bother to spend any additional money. Use your Mac while using Windows for MS Access or whatever your school requires. I do not suggest using a third party Mac product when it comes to school stuff as you want to follow the course instructions and not be confused by GUI issues and possible limitations - but in the real world, plenty of open source solutions when you're outside of school.

    -jim
     
  5. raymondu999 thread starter macrumors 65816

    Joined:
    Feb 11, 2008
    #5
    Well, it's not really the class. The class is platform-neutral :D The only thing is that for my project, I ahve to use some kind of database, and my groupmates (despite another Mac user) were the one who pushed the idea of having Access. My lobbying for the use of MySQL, sadly, came out unfruitful.
     
  6. SrWebDeveloper macrumors 68000

    SrWebDeveloper

    Joined:
    Dec 7, 2007
    Location:
    Alexandria, VA, USA

Share This Page