Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Microsoft Access on a Mac
Bruce McCormick 
   
17 months ago
Thank you for considering the following!

This thing i've been working on for the last 6 months (that i speculated would be done in a month) for my friends (i hope they still are) has been on my PC. She runs a MAC. What possible issues should i look out for in:
1) VBA Code
2) Output
   a) Screen
   b) Print
   c) eMail (the old fashioned spelling!)(sent using the "Rost GMail Technique")
3) Splitting the db into FE/BE
4) Creating what we in the PC/Windows world call "Trusted Locations"
5) Creating Sub-directories off the main db for the BE, Images and Documents (three separate, one for each of those)
6) For any additional libraries i might have included
7) And anything i might not know enough about MACs to ask

She (end user) is running MS Office 2019 for MAC (that, or 2021)

Thank you for your time, knowledge and kindness!!!

Best Regards,
-Bruce, Lord of the River Dance (i've decided to make that my designated "pronoun")(pronoun, or title. Can't decide yet, just started my coffee and my back is rather painful right now, so a distraction)
Sami Shamma  @Reply  
             
17 months ago
The simple fact that Access does not run on a Mac. period.
Emulators are your only option.
Bill Carver  @Reply  

17 months ago
THere's a few things you can try.
One is a program called parallels which will allow windows to run on that mac.  It takes a little horsepower, but I find that with unity mode it's pretty darn good.  Access will look like it's running right next to the mac stuff
If you have a citrix server, set up access on a virtual machine there and let the mac connect to it.  If that doesn't happen for you access fortunately does not need a lot of horsepower to run.  You can set up a "headless" pc.

I know normally links are shunned here, but there is a store that sells refurbished off-lease pc's.  You can get something capable of running access for about $149.  Set it up, Set up remote desktop and your mac can remote into that.

THe link to the refurbished computer page is:  (should it be accepted in this case)  This is just one store.  There are probably other stores that also sell refurbished comnputers.

https://www.microcenter.com/search/search_results.aspx?N=4294967292+519&NTK=all&sortby=pricelow
Alex Hedley  @Reply  
           
17 months ago
Sure VMWare Workststion went free recently
You'd still need to buy a Windows License and Office License
https://cybersecuritynews.com/vmware-workstation-free-users/
Jeffrey Kraft  @Reply  
      
17 months ago
Since links ain't allowed. D. Pineault has a YouTube video where he covers that topic (almost a year ago). Near the end of the video he mentions a  program called CrossOver. I don't have a Mac. Never had a Mac. Never owned an IPhone. The quick Google search says Hosted desktop services, virtualizati0on, install Windows on a Mac, third part software (emulators), use FIlemaker (but that doesn't solve your problem).
Bill Carver  @Reply  

17 months ago
THanks Alex.  THe one advantage to my solution is that the windows installation, usually professional to boot, is included in the 149 price.
Bruce McCormick OP  @Reply  
   
17 months ago
First of all, Thank you. Everyone.

Once again i must question how many marbles i may have dropped along the way, for i truly thought they downloaded an Office package including Access for the MAC.

btw Mr. Kraft, i have four daughters; all were indoctrinated into MAC by our marvelous public school system. I learned a little about MACs having to sometimes help them, but i am proud to state that they all converted to PC after a little time in the real world. A mentor of mine once said "MACs make great printer spoolers".

I do however prefer the iPhone. I only used the Android variety for about 6 months after having used iPhones for several years, and it took overcoming significant personal resistance and shaming to even get me to try an iPhone at first. Either Android has a great advantage about it that i am unaware or it simply is a matter of personal preference.

That which all you good folks have written suggest to me that my best course now is either to convince them to get a PC, if for nothing else, this use, or perhaps harakiri (had to look that one up...).

Thank you.

Best Regards,
-Bruce
Bruce McCormick OP  @Reply  
   
17 months ago
I now, with the realization evolving from shock, came to the point of seeing my reaction being the perfect motivation to play the Christmas Vacation scene by Clark Griswold when he opens the letter being his company bonus and finds it is enrollment in the "Jelly of the Month" club, but this one is my fault. "Hallelujah, ..., where's the Tylenol".

Mr. Rost, if you ever do put together a listing of "Most jackass moves", you may use this as your chart topper, but as important, let it serve as a lesson to all out there. I once wrote Mr. Rost that there should be a video on all the planning that should occur prior to embarking on a project, and though i agreed with him, that such a video would be horridly dry, besides all the parameters of scope, i now found the primary fundamental one: Make dam# sure what you are doing will actually run on their system.
Jeffrey Kraft  @Reply  
      
17 months ago
Mr. McCormick. In my Senior year of high school way back in 1983 we had Apple 2 or 2E, the Mac would be released in 1984. Community college also had Apple 2E. I figured great strategic move by Apple to introduce those machines to the up and coming work force, however will/would Apple be able to break into the IBM controlled world.  I started with a Commodore 64 and was going to go to an Amiga of some sort - or an Apple something or another but cash was limited and I wouldn't revisit the topic until Windows was released and got my first Compaq Computer.  I kind of liked the Mac's but every program I was using was PC based.

I recently visited the college I went to. They updated the computer "lab/room". Apple still has a grip on one half the lab, but now it's Mac's. The other half is Windows related.  

My dad thought the computer thing would be a fad, much like CB radios.  Boy was he wrong!!!! Somewhere in the '90's I became the "Cheap Labor" to bring my dads office into the computer world.

My "Novel" is done.
Bill Carver  @Reply  

17 months ago
Fortunately Bruce if they purchased office 365 for the mac they can also install office on a pc so technically they did get access with the mac version.  Just not for the mac.

For those mac people that will insist on not using anything microsoft, there is a good relational database called filemaker which works like access but It cannot read access files.  IT's its own sandbox essentially.  Filemaker is available for windows and mac but is not as powerful with scripting as access is and you'd miss all this wonderful help that you can get here.

BTW... 599CD.com is far superior to microsoft help.
Bruce McCormick OP  @Reply  
   
17 months ago
To give credit where credit is due, the MAC, like the PC, is an amazing piece of work, and if the story about being developed in Job's garage is true, that much more amazing. I too think the strategy of getting them into the school system was outstanding. The PC folks didn't have the unified presence so could not collaborate to such an effort. I'm about done from kicking myself in the backside over this; for what i have developed, even though it is far from complete, they would be at a loss to buy a PC at today's prices; and that is presuming they don't have one around anyways.

Now to get back to the moving arrangements and looking forward to replacing a half shaft in one of my daughters' cars, probably on Wednesday, when the low is expected at 15 and the high at 31, and yes, that is Fahrenheit...

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/16/2026 4:12:30 PM. PLT: 1s