Microsoft Access on Mac OS

Discussion in 'Mac Basics and Help' started by silence, Aug 29, 2006.

  1. macrumors member

    Joined:
    Jun 1, 2005
    #1
    Hi, I work in a PC dominated work environment, and we are using a Microsoft Access database. I need to at least view the database on my computer too!

    I have MS Office installed, but apparently it doesn't come with Access. :confused:

    Is there a versioun out for Mac? If not, are there any third party applications that can allow me to view Access databases? ?

    Any help would be much much appreciated!!!!!!!

    Thank you
     
  2. thread starter macrumors member

    Joined:
    Jun 1, 2005
    #2
  3. macrumors 601

    mjstew33

    Joined:
    May 29, 2005
    Location:
    Illinois
    #3
    What Mac are you on? You might have to go through Parallels if you're on an Intel. :(
     
  4. macrumors 6502a

    spinne1

    Joined:
    Mar 12, 2005
    Location:
    Hermitage, TN USA (near Nashville)
    #4
  5. macrumors 65816

    20rogersc

    Joined:
    Jun 28, 2005
    Location:
    Brighton, UK
    #5
    FileMaker is a well known database app for Macs.
    Here it also talks about an Access 'importer', FmPro Migrator.

    Hope this helps.

    ::20ROGERSC::
     
  6. macrumors G5

    Sun Baked

    Joined:
    May 19, 2002
    #6
  7. macrumors 65816

    Joined:
    Jun 18, 2005
    Location:
    California
    #7
    Very good freeware would be Open office which has access support.
     
  8. macrumors 6502

    gman71882

    Joined:
    Jan 12, 2005
    Location:
    Houston, Tx
    #8
    I have this same Access problem, SO I'm Downloading OpenOffice now, going to test it with a M$ Access file. Hope this works. A $3000 job is riding on this. :eek: :D
     
  9. macrumors 6502

    gman71882

    Joined:
    Jan 12, 2005
    Location:
    Houston, Tx
    #9
    No Luck, cant get Open Office to read a M$ Access file... anyone else have any luck:confused: :confused: :mad: :mad:
    Or maybe a PC i can borrow??? hehe
     
  10. thread starter macrumors member

    Joined:
    Jun 1, 2005
    #10
    Gosh if only Access was included in Microsoft Office for Mac :mad:

    This is turning out to be a very expensive oversight.. From what it sounds Open Office isn't operational yet, so my only alternative is to purchase FileMaker Pro for all 10 computers!!!! Just because my 1 mac can't view Access files..

    Well Access is pretty crap anyway, so i guess its a better step up moving to Filemaker.. an expensive one at that..
     
  11. Moderator

    balamw

    Staff Member

    Joined:
    Aug 16, 2005
    Location:
    New England
    #11
    At least consider migrating your DB tables at least to one of the many versions of MS SQL Server. Access is a toy, SQL server is a database, and you can make very nice web front ends for it.

    B
     
  12. macrumors G5

    Sun Baked

    Joined:
    May 19, 2002
    #12
    Try CrossOver or Parallels... and run the Windows version of the app.
     
  13. macrumors 6502

    Joined:
    Jul 4, 2006
    Location:
    London, UK
    #13
    Can you move them across to MySQL instead? Nice free db.
     
  14. macrumors newbie

    Joined:
    Aug 20, 2008
    #14
    Microsoft Access

    People,
    Microsoft Access is a hugely powerful, flexible development environment.
    It is not a toy and it is certainly NOT an end user tool.
    This is Microsoft's big error - telling people it is a database system for end users to create their own relational databases. Nor are Filemaker, Approach, INGRES, Oracle... etc. end user tools. They are all database management systems and application development environments for use by professionals. If you let a user loose with Filemaker they are just as likely to mess it up - just ask your average user to describe Normalisation...
    My company supports over 500 organisations using our systems developed using MSAccess in front of SQL Server or SQL Express. We have not had a single days downtime in more than 12 years.
    There are sites with many milliosn of records on the systems and scores or even hundreds of concurrent users. In parallel we also have remote users accessing the same backends through asp or .net based online applications.
    It all works extremely well.
    Please stop talking about Access unless you too have developed enterprise scale applications using it.
    Regards
    Jim Moores
     
  15. Moderator emeritus

    sushi

    Joined:
    Jul 19, 2002
    Location:
    キャンプスワ&#
    #15
    Microsoft is an interesting company when it comes to marketing their products on the Windows side of the house.

    Looking at Microsoft Office regarding the standard apps (Word, Excel, PowerPoint and Access).

    Windows Versions (US)
    - Professional (Word, Excel, PowerPoint and Access)
    - Standard (Word, Excel and PowerPoint)

    Windows Versions (Japanese)
    - Professional (Word, Excel and PowerPoint)
    - Standard (Word and Excel)

    If you just need to look at the data while on the go, you could look at exporting into Excel.

    If you want to be able to review, change and edit data, then probably the easiest way is to run Windows XP via Parallels or VMware, and then run the Access application that way.

    One issue is compatibility. In the past 8 years, there have been the following Access versions: 2000, XP(2002), 2003 and 2007.

    AFAIK, and I am sure someone may know of an exception, there is no other DBMS system out there than can merely open an Access database, edit the database (record/field structure, forms, reports, queries, etc.), add/delete records (data), and be totally compatible. That is why my recommendation is to go with the solution above.

    If on the other hand, you just need to see the data, there are a variety of options available to view the data.

    DBMS are not for everyone. :)
     
  16. macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #16
    I have to agree with most of what's said here, although since this is your first and only post in the forums, I think you may have just been looking for a way to plug your company. I've been, among other things, a database consultant for many years and I can tell you that a great many clients come to me after they attempt to build their own database using Access or similar tools. Then they pay me to clean up their mess. In some cases, it would have been cheaper to hire me to build what they wanted from scratch.

    As I frequently tell my clients about building databases, editing the Windows Registry, or other such things: "Kids, don't try this at home!"

    As a side note, you DO realize this thread is 2 years old, right?
     
  17. macrumors newbie

    Joined:
    Aug 20, 2008
    #17
    Microsoft Access

    I did realise the thread was two years old but unfortunately searches still bring it up as "current" because of course for all intents and purposes it is.

    I was simply looking for up-to-date advice with Access on MAC as, despite having 500 customers, I have just encountered the first one who insists on a mix of PC and MAC.

    I make no attempt to promote my company to the MAC community and you may have noticed I did not specify my company name.

    Perhaps we should ask the forum mediator to take off such old posts that are also quite inaccurate, but clearly anyone can say anything and there does not have to be any basis in fact.

    Going back the the main point I too have undertaken many jobs re-wrting, or indeed replacing, systems written by "consultants" in Access, FoxPro, Approach, Filemaker... You are absolutely right, and we advise clients as strongly as possible to think carefully before developing a system themselves. It never works and whichever RDBMS you use you need to know what you are doing.

    Come back Dataease...
     
  18. macrumors member

    Joined:
    Jul 29, 2008
    #18
    I guess thats why it's called the MacRoumors forum and not the MacFacts forum ;)
     
  19. macrumors newbie

    Joined:
    Sep 19, 2008
    #19
    I agree with Jim. People who call Microsoft Access a toy do not know what they are talking about. I work with Access every day and maintain a database consisting of thousands of records. This DB also is accessed by users via a front end website running asp. MS Access is a powerful tool for people that know how to use it properly. Secondly why a person fluent in Access and who has used it for years developing applications would want (or need) to start learning from scratch in Filemaker to achieve the same proficiency is beyond my understanding, and if anyone calling themselves a professional does this simply to use a Mac instead of a PC then they are not very professional in my opinion, considering how inexpensive decent PCs are. I have a dedicated PC running windows XP Pro specifically for MS Access, but also run it on the road on my Intel 2.5 Macbook Pro when needed (i.e. when travelling). I still do all layout, prepress (Adobe CS), email and office apps on the mac, but Access is simply one of those applications which necessitates a PC with Windows. Any Mac-inclined Access professional worth his salt knows and accepts this.
     
  20. Moderator

    balamw

    Staff Member

    Joined:
    Aug 16, 2005
    Location:
    New England
    #20
    Since I originally made the toy comment, let me clarify.

    It should be clear that from my comment that I made the common mistake of referring to JET as Access. I reiterate, as a database JET (formerly the default database used by Access, Outlook, etc..) is a toy which doesn't scale well at all and should at all costs be avoided. I've run into its limitations so many times that I have come to hate it.

    That said, Access is a a great tool for generating front-ends and creating reports etc... but that is not what I was talking about. I was merely referring to the back end stuff that most existing Access data is stored in.

    This is not meant as a personal attack, but if you think that databases with thousands of records are big, you are the one that doesn't seem that experienced. I work with a SQL database in a small manufacturing environment where a single test generates thousands of records in a table and those databases are toys. Imagine dealing with the data generated at the LHC or the inventory system at Amazon/Wal-Mart/Costco, etc...!

    B
     
  21. macrumors newbie

    Joined:
    Aug 20, 2008
    #21
    MSAccess

    People, can we end this by saying JET is NOT a robust, enterprise database engine. In saying that I have implemented systems for many, many users with an Access backend, in multi user environments, and we have never lost any data - it's all about controlling access to data, and managing security and concurrency, programatically

    I referred to millions of records, not thousands.

    SQL Server is a much better backend RDBMS and with SQL Express you can use it free of charge with your Access frontend. MySQL is another excellent alternative and is likewise free.

    Thank you.
     
  22. macrumors newbie

    Joined:
    Sep 19, 2008
    #22
    Ok, maybe I wasn't being clear, when I said thousands of records, I meant not as in one or two thousand, but more in the region of 50 thousand. Granted, this is still small compared to the organizations you mention at the end of the paragraph, but for the purposes of the databases I maintain, Access is the tool of preference because the reporting features are in my experience superior to some other DB reporting tools. The main point I was making in my post, is that people who are experienced and proficient with MS Access but who, given the choice, would prefer to use a Mac, simply have to accept that a PC is a necessary tool. I love my Macs and if Access was available for mac with the full functionality available as on the Windows version, I would probably not use another PC again. However, even if MBU did release a Mac version I think for it to reach a viable level of maturity and stability as an application would (judging from having used the last 3 versions of MS Office for Mac) take 3-4 re-releases of the product.
     
  23. Moderator emeritus

    sushi

    Joined:
    Jul 19, 2002
    Location:
    キャンプスワ&#
    #23
    The simple most easiest to solution is to get VMware or Parallels, set up a virtual machine with Windows XP and install Office Pro Windows.

    Now you will have a way to view, edit, etc. Microsoft Access files.

    If you decide to wait for Access on the Mac, you will be waiting a very long time.
     
  24. macrumors newbie

    Joined:
    Oct 23, 2008
    #24
    Use Data Access Page

    They are extremely easy to create. Create just as if you are making a new table/query/report. When you're finished just click publish and it gives you a url. You can view and edit the information through your web browser. For more information, see the help topics under data access page.

    Hope this helps.
     
  25. macrumors newbie

    Joined:
    Oct 28, 2008
    #25
    microsoft access....

    hello,I'm Rachel, my professor installed a mac office tools in my macbook but still the other applications didnt work.. only the excel thing is working.. i need access we are using database in our computer engineering subject..anybody would kindly help me please?
     

Share This Page