Access DB files

Discussion in 'Mac Apps and Mac App Store' started by joetronic, Jun 14, 2005.

  1. joetronic macrumors 6502

    Joined:
    Dec 9, 2004
    Location:
    New Oxford, PA
    #1
    I need a application that can open and edit Access DB files. My boss is thinking of getting me a mac since I am the only mac guy in the office, bu tI need to be able to do everything I need to do for my job on it, and show her that it can. I have already figured the Novell Admin stuff (console 1, nwadmin, GroupWise, Zen Mgmt, ect....) but I am stuck on the access stuff. I need to be able to open a file, edit it, but keep it so Windows users can open it as well. Is there any application that can do this. I am on a strict time frame, as we need to place the order before the end of the fiscal year, July 1st.

    Thanks in advance for your help.
     
  2. MisterMe macrumors G4

    MisterMe

    Joined:
    Jul 17, 2002
    Location:
    USA
    #2
    Only Access can access Access DB files.
     
  3. yellow Moderator emeritus

    yellow

    Joined:
    Oct 21, 2003
    Location:
    Portland, OR
    #3
    Yep.

    So you need either access to a PC with Access installed or you could give VPC a shot. I have no idea if VPC and Access play nicely.
     
  4. joetronic thread starter macrumors 6502

    Joined:
    Dec 9, 2004
    Location:
    New Oxford, PA
    #4
    so there's no Unix app that can. even if I have to run it from X windows that would be fine. I kinda recall a app in in my UNIX days, but cannot remember what it was called. I have done a Google and a search here but cannot find anything. I really want to be able to do this without VPC, as she will just say why not just use windows. She is totally Microsoft Power to the max.
     
  5. DavidLeblond macrumors 68020

    DavidLeblond

    Joined:
    Jan 6, 2004
    Location:
    Raleigh, NC
    #5
    Well you can edit the data WITHIN Access DB files with an ODBC driver... never tried it on the Mac tho.
     
  6. joetronic thread starter macrumors 6502

    Joined:
    Dec 9, 2004
    Location:
    New Oxford, PA
    #6

    Oh yeah, I forgot about ODBC. I will give that a try, as as long as I can edit the data, I'll be good.

    While I'm trying this I'd still like more opinions.

    thanks
     
  7. DXoverDY macrumors 6502a

    Joined:
    Apr 19, 2005
    #7
    You're gonna find yourself in a problem here. You'll have to go the VPC + Office route... just that simple.

    Good luck finding this mystery app that does what you want, it doesn't exist to my knowledge.
     
  8. joetronic thread starter macrumors 6502

    Joined:
    Dec 9, 2004
    Location:
    New Oxford, PA
    #8
    well, I just talked to my boss and told her the situation. We decided to go with a beefier mac and the VPC route. I still think this should be able to be done a different way. I find it hard to belive that there is no way to edit Access DB files on OS X. Now its driving me nuts.
     
  9. DXoverDY macrumors 6502a

    Joined:
    Apr 19, 2005
    #9
    man, it's a microsoft technology. microsoft doesn't just open it up and say "have at it." they also don't have a versoin of access for the mac. you find it hard to believe that someone hasn't taken up the project and made an app? i'm sure someone has and found out it was more trouble than it was worth. not to mention a waste of time since there are much better applications out there anyway.

    it's a reality. you aren't always going to find some free app to do what you want man. if you have such a problem with it, go hound microsoft and make it a point they need to make a mac product for access.
     
  10. sakasune macrumors member

    Joined:
    Mar 12, 2004
    #10
    Hmm...a bit of a tougher option, but still requires a Windows machine. If you or someone you know can code in ASP, you can host the ASP pages on a windows machine and work with the database through your web browser on your Mac. I built a time-clock program in ASP for my job, it recorded worker info, time punches, etc in an Access database. The ASP pages can even make queries to the database and display them on the page. I also know Safari can view ASP pages, but you can't host them in Apache, it doesn't support it.
    There also might be a way to get into an Access database with PHP (Apache can host PHP pages by editing one line in a config file), but I know nothing of PHP...freakin' school teaches MS crap (VB.NET, ASP.NET), at least they taught about Java and Oracle.
     
  11. joetronic thread starter macrumors 6502

    Joined:
    Dec 9, 2004
    Location:
    New Oxford, PA
    #11
    I never expected MS to make it possable, but you would think some unix guy has made a app that lets you edit the files since there is a way to edit just about any other file format out there. Just my .02

    thanks for all the replys.
     

Share This Page