Results 1 to 11 of 11
  1. #1

    Filterlab's Avatar
    Member Since
    May 17, 2007
    Location
    East Molesey, Surrey, UK.
    Posts
    23
    Specs:
    Intel iMac, MacBook Pro, MacBook Air, iPad, iPhone 4, iPods, AirPort blah blah
    Running MS Access in Windows via Parallels
    Ok, new here so I'll just blast the question out and see what comes back:

    Situation:

    I've been into Macs for quite a while now but our business ,of which I am the manager, is now looking to replace its aging computers with something White and slick (and I don't mean George Michael's latest release).

    Since we mainly use Excel and Word for our documentation we're pretty well catered for to shift over to Mac. However, the sticking point is MS Access upon which our whole business revolves. Since we don't want to transfer our existing records to a similar Mac application, as we have built and extensively adapted our database to meet our exact requirements, we have to run Access on a Mac. Now the thought of having to boot our machines every few minutes into either one or another operating systems is a bit of a curdler as in business we simply don't have the time. Conclusively 'Parallels' seems like the ideal way to go as we can have everything Mac except one window which runs XP.

    Could anyone who has specific experience of running Parallels give me some feedback as to how well it works, and moreso if any problems have been experienced along the way and how they were cured. If anyone has experience with Access on Parallels then any info would be highly appreciated.

    Access is a particularly picky piece of software, although undoubtedly good, and the slightest thing can upset it so before I put my MDs business (and my 50k salary) on the line I'd like to be sure that a Mac will run Access ok.

    The machines which are not yet purchased are likely to be five 20" 2.16Ghz Intel iMacs running on a peer to peer network with one host and four clients.

    Sorry for a mad long post but since it's a business thing I have to be sure that everything's covered.

    Cheers!

    BTW, I'm not into Microsoft bashing as I believe they make a good product that the business world understands and uses with reasonable fluidity. Macs on the other hand are targeted more at creativity, reliability and flexibility. Different machines for different uses, although there's no reason why Mac can't be prolific in both arenas.
    I just can't get enough of that Apple loveliness! Piled up they are, piled up around the house - like acrylic and aluminium testaments to Apple's genius. And they all work perfectly, obviously.

  2. #2

    Filterlab's Avatar
    Member Since
    May 17, 2007
    Location
    East Molesey, Surrey, UK.
    Posts
    23
    Specs:
    Intel iMac, MacBook Pro, MacBook Air, iPad, iPhone 4, iPods, AirPort blah blah
    Cheers.
    I just can't get enough of that Apple loveliness! Piled up they are, piled up around the house - like acrylic and aluminium testaments to Apple's genius. And they all work perfectly, obviously.

  3. #3


    Member Since
    Oct 27, 2005
    Posts
    4,702
    Quote Originally Posted by Filterlab View Post
    Cheers.
    Suppose you're finishing a brochure on your Mac, and you need a phone number from your company's Microsoft Access database. You double-click the Parallels icon, and 15 seconds later — yes, 15 seconds — Windows XP is running in a window of its own, just as you left it. You open Access, look up and copy the contact information, click back into your Mac design program, and paste. Sweet.
    The above quote was taken from here.

    -----


    Parallels Desktop for Mac lets you run thousands of popular Windows programs, plus many that are not available for the Mac, including ...

    Microsoft Access
    Microsoft Outlook
    ACT!
    Goldmine
    Microsoft Project
    Microsoft Visio
    Microsoft Money
    Microsoft Publisher
    Art Explosion Publisher Pro
    Microsoft FrontPage
    Hallmark Card Studio
    Scrapbook Factory Deluxe
    PrintMaster
    Punch Home Design Software
    Plus thousands more!


    Taken from this link.

  4. #4


    Member Since
    Jan 29, 2008
    Posts
    2
    Regarding Access on Parallels
    Hello Filterlab,

    I'm wondering if you made the switch to Macs and used Parallels to run Microsoft Access--and if you did so, how is it working for you?

    I have an Intel Mac and am about to commit to managing a database using Access. I've never tried to run Windows on my Mac and haven't seen much about running Access, so I'd really appreciate knowing what the experience has been for you. Thanks!

  5. #5

    Zoolook's Avatar
    Member Since
    Sep 24, 2006
    Location
    Brooklyn, New York
    Posts
    2,756
    Specs:
    15" MacBook Pro, i7 2.66Ghz, 8GB RAM, 512GB SSD; iPad 3, iPhone 5
    Access works fine, end of story. I use countless tactical apps via access and have never known any to fail - even some that access Oracle databases on the network.

    Access seems to work fine in coherence mode too, so you can just have the access app on your OS X desktop. HOWEVER you absolutely MUST have the database on either a windows network, or on the parallels virtual disk, not the OS X extended disc.
    In the land of the blind, the one-eyed man is stoned to death.
    - Joan D. Vinge


  6. #6


    Member Since
    Jan 29, 2008
    Posts
    2
    Thanks for your response & info, Zoolook--and the tip.

  7. #7


    Member Since
    Jun 10, 2009
    Posts
    1
    trouble with Access
    I'm running Parallels ver 4, Leopard 10.5.7, and Windows XP Pro on a Mac Pro with 12 gig ram. MS Access runs fine, well, as well as can be expected ;-), on several Windows XP PCs. I have the data file on a dedicated PC running XP Pro.

    But in Parallels, Access is generating errors in the data file. It's corrupting the file. The symptoms are similar to a problem I had several years ago when I was sold a Linksys Network Attached Storage box to serve the data file. CDW neglected to tell me that these boxes are not suitable for hosting a database, since they can drop the connection to the network for very short intervals of time, fractions of seconds. But that's all it takes to cause data corruption in an Access file.

    I have the virtual machine running in bridge mode.

    The error message I get reads something like, the Jet database can't connect because you are trying to connect to a table at the same time as another user is trying to connect. But this happens even though the Mac Pro is the only computer connected to the data file.

  8. #8


    Member Since
    Jun 20, 2009
    Posts
    2
    I use a PC for Windows programs - I tried using Parallels on my wife's iMac and between Time Machine, Parallels, the computer hung horribly. I had never had any problems on the iMac for the two or three years or so we have had it. Unlike Windows machines. So, I would keep a Windows PCs for Excel, Word and Access and use Macs for graphics (I have just bought a Mac Mini for videos and photography).
    I returned Parallels to Office Depot (had to write to the CEO before I could return it). Main thing with PC is that if they are a reputable make and if you run good virus software and if you ensure that your employees will not practice unsafe computing, the PC will be just fine. I run AVG and Perfect Disk so as to ensure that the PC is optimized constantly.
    I will not mix Windows and Mac software on computers now, I have spent way too much time in rebuilding, repairing, etc.

  9. #9


    Member Since
    Jul 24, 2010
    Posts
    1
    Access Database running in Parallels
    I am new to the forum, Running my business in two separate database situations. One is a independent program called IPM running a post and report system that had written 10 years ago to maintain my Mortuary Insurance Company Collections and Reports. Through a regular and periodic database maintenance allows the Access program to run smoothly and have managed to maintain records for 10 years with little or no errors.

    The other database that I call Merged Funeral is a simple one tied to MS Word documents for merging data into our frequently used forms for a clean and neat hard copy as well as computer record. However recently having to upgrade to preserve and maintain my files, I felt that upgrading to an IMac with the use of Parallels along with XP would be the solution. Now that I have the IMac loaded properly and data in place, the simple database (running on the desktop with shortcuts to the MS Word documents as well as the Access database for the records linking 3 tables together) On the opening of the Merged Funeral database, appearing in the dialog box with the 3 table icons; about a week of using this database in Parallels I have come on a error (making the Form Icons Disappear leaving a Dark Gray panel) that is produced by simply moving the mouse to the upper right hand corner of the dialog box making the Form Icons disappear and a slider bar at the bottom of the dialog box slam to the right in a unmovable fashion as if a spring was sprung and will not go back to the left.

    When checking the database icon in the desktop it reads to the same size as before the mouse made the fatal disappearance of the Form Icons. As soon as I restore with my back up, the dialog box is back to normal. However repeating the same mouse strokes make the Form Icons disappear again, so far the only way I can prevent the Form Icons from disappearing is to minimize the Access Database Box exactly to the size of the Icon Form Box. (one occurrence I was able to restore to the Form Icons by clicking in upper box area following the disappearance)

    Anyone had a similar problem?

    Desperate to use the IMac but not to lose my data!!!!

  10. #10


    Member Since
    Sep 04, 2014
    Posts
    1
    Access in Parallels
    I downloaded the MS Access from the Dreamspark site through my school but don't know how to install it. Do I do this on the Parallels or Mac side?

  11. #11

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,818
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    This is a very old thread. You really should start a new thread, however, I will try to answer your question.

    I downloaded the MS Access from the Dreamspark site through my school but don't know how to install it. Do I do this on the Parallels or Mac side?
    Since MS Access is a Windows only program it must be installed from within Windows running in Parallels. And that's assuming you have a legal licensed copy of Access and Windows.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. running windows 7 in parallels
    By jpforum in forum Running Windows (or anything else) on your Mac
    Replies: 5
    Last Post: 11-29-2012, 09:07 PM
  2. Running windows 7 using parallels on an external hd
    By dowser81 in forum Running Windows (or anything else) on your Mac
    Replies: 2
    Last Post: 09-11-2012, 07:16 PM
  3. Antivirus if running Windows XP in Parallels?
    By EORI in forum OS X - Apps and Games
    Replies: 5
    Last Post: 12-09-2007, 04:15 PM
  4. Running Windows on Parallels AND Bootcamp?
    By fleurya in forum Running Windows (or anything else) on your Mac
    Replies: 5
    Last Post: 02-03-2007, 12:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •