This particular client uses Access quite often and needed to be able to use the database program on his Mac. The latest version of Microsoft Office 2011 for Mac does not contain the Access Here are a few points to remember if you are going to use Parallels on your Mac to use Microsoft Access 2007. Alternatives to Microsoft Access on the Mac File Maker Pro. FileMaker is probably the best known database application for the Mac. It has a feature set comparable to Microsoft Access, but with a strong focus on forms (layouts) as the primary way of accessing databases.
MS has been trying to move away from Access for a very long time, but the user base is making it very difficult for them. I am guessing this is why they do not include it with Office for Mac, since they don't even want it on Office for Windows anymore.
Even with the free version of SQL Light (not it's actual name, but I forget what it is called) many users are afraid of making the switch, since they loose the single-file database they have been using for so long. I have that situation at work right now. To my knowledge, there is no native Mac software to edit or even read an MS Access database. You have to export the data in Windows to a cross-platform friendly format (Excel, XML, etc) and then import it back if you make changes to it outside of Access. I don't imagine this is going to change.
Click to expand.It's not merely a matter of 'want to' on the part of Microsoft or Apple. Microsoft Access uses the Microsoft Jet Database Engine. That Engine is deeply integrated into a host of Windows technologies. It's a lot more complicated than a Word Processor or Spreadsheet. Ensuring cross-compatibility and data integrity would be a huge undertaking, for likely a very small market. Most applications could be solved by using a spreadsheet (seriously) or else moving to a SQL-basd technology that could be far more compatible across platforms. MS has been trying to move away from Access for a very long time, but the user base is making it very difficult for them.
I am guessing this is why they do not include it with Office for Mac, since they don't even want it on Office for Windows anymore. Even with the free version of SQL Light (not it's actual name, but I forget what it is called) many users are afraid of making the switch, since they loose the single-file database they have been using for so long. I have that situation at work right now.
To my knowledge, there is no native Mac software to edit or even read an MS Access database. You have to export the data in Windows to a cross-platform friendly format (Excel, XML, etc) and then import it back if you make changes to it outside of Access.
I don't imagine this is going to change. Click to expand.You go to your university's computer lab? Good for you. I never understand why people constantly say things like: Why do you need access?
I just use VMWare I just use another computer. I just use a different database. Blah blah blah. That's YOUR solution. Some people have genuine use for an application in their own environment. People should stop making ridiculous suggestions. I can't imagine the ordinary joe (especially people not used to the windows environment) installing that workaround.
Also, some people may have a complex spreadsheet already programmed, and they have migrated to OSX, and they don't want to have to spend another 1000 hours programming time to convert it all (in my case) because it is hooked up with a database. My spreadsheet and db needs portability between osx and windows, because much to my surprise (SHOCK HORROR) people use windows - and last I knew, my 63 year old colleague didn't have access to a 'university lab computer'. Installing VMware then having to install windows, then having to install office is just NOT a practical solution to run one application. Let alone the cost of doing that. The original question was WHY can't microsoft negotiate with apple to include access in it's OSX version of office. I for one would welcome this, because I have to fire up vmware with windows and office every time I want to run my spreadsheet that has access at it's back end.
A royal PITA. All this said I have a feeling it (ms access in OSX ms office) will never happen. Click to expand.Its been answered - MS has been trying to move away themselves - the cost of migrating the program over is way too costly for them to consider and even if they got the basics down there would be no way for them to ensure it would work properly due to Jets reliance on Windows stuff. This isnt like making a mac version of word. Access was never designed with cross platform in mind and is a darn complicated program.
Its just not worth it for them and nothing that Apple is going to tell them will likely change that. There are tons of easier programs for MS to convert over in the office suite (One Note, Project) that they stubbornly refuse to move over. Heck it took forever for Mac users to get Outlook (and even then its not the same as the PC version as far as support goes).
The simple answer remains is that MS doesnt want to invest in a major project that may not succeed to accommodate users that they want to move to another platform (like MS SQL) anyhow. Its been answered - MS has been trying to move away themselves - the cost of migrating the program over is way too costly for them to consider and even if they got the basics down there would be no way for them to ensure it would work properly due to Jets reliance on Windows stuff. This isnt like making a mac version of word.
Access was never designed with cross platform in mind and is a darn complicated program. Its just not worth it for them and nothing that Apple is going to tell them will likely change that.
There are tons of easier programs for MS to convert over in the office suite (One Note, Project) that they stubbornly refuse to move over. Heck it took forever for Mac users to get Outlook (and even then its not the same as the PC version as far as support goes). The simple answer remains is that MS doesnt want to invest in a major project that may not succeed to accommodate users that they want to move to another platform (like MS SQL) anyhow. Click to expand.Thanks. Yep and I got that but my original spray was about how people constantly offer unrealistic workarounds for people or try to persuade them to use a different product without actually addressing the original poster's question. Just as another example: I saw a post where someone asked about installing NT4 on a SATA based motherboard.
The reply the poor chap got was 'why do you punish modern hardware with a crappy old OS. Just upgrade to windows 7'. What that bozo doesn't realize there's a lot of industrial legacy gear that will ONLY run on NT because the software was written for that platform. People don't just use computers to play Diablo III. Thanks again for you detailed reply. I'm sure the original poster will appreciate it. It is really hard to tell what you are trying to do or rather, what you want to do here with Access.
ODBC for Mac has been around for a while. Filemaker Pro with some tweaking can do much of what Access does (and more) and of course runs on Mac.
Then again, Access is for many of us either a desktop app or a front end to real databases and not much more. If Filemaker is not your thing, try some of the small footprint SQL offerings including those ported over from Unix/Linux.
Last I recall Open Office has a database that works on OSX (lightweight SQL). You go to your university's computer lab? Good for you. I never understand why people constantly say things like: Why do you need access? I just use VMWare I just use another computer.
I just use a different database. Blah blah blah. That's YOUR solution. Some people have genuine use for an application in their own environment. People should stop making ridiculous suggestions. I can't imagine the ordinary joe (especially people not used to the windows environment) installing that workaround. Also, some people may have a complex spreadsheet already programmed, and they have migrated to OSX, and they don't want to have to spend another 1000 hours programming time to convert it all (in my case) because it is hooked up with a database.
![Micrsoft Access For Mac Micrsoft Access For Mac](/uploads/1/2/5/4/125452098/990331017.jpg)
My spreadsheet and db needs portability between osx and windows, because much to my surprise (SHOCK HORROR) people use windows - and last I knew, my 63 year old colleague didn't have access to a 'university lab computer'. Installing VMware then having to install windows, then having to install office is just NOT a practical solution to run one application. Let alone the cost of doing that.
The original question was WHY can't microsoft negotiate with apple to include access in it's OSX version of office. I for one would welcome this, because I have to fire up vmware with windows and office every time I want to run my spreadsheet that has access at it's back end. A royal PITA. All this said I have a feeling it (ms access in OSX ms office) will never happen. Click to expand.
There is always MySQL or more universal DB systems. Many have free to pay visual 3rd party of varying quality to skip command line fun. Other aspects of this as mentioned is ms access has lots of deep rooted M$ technologies that just won't port over easily.
Hell, the jet engine and required dependent technologies can have issues in its own native OS environment. The day M$ tech works across years of computers, os installs and patch levels of certain M$ features will be the day many IT peeps go jobless. Till that day comes.there will always be a tech hammering out problems in this area somewhere.