I don't think there is any way without remoting into a windows machine or having a dual boot OS. But see what Alex says.

Alex Howdy, I got mine to work but had to set up virtual windows.  What you said about access and MAC is TRUE and it's not going to happen.  I also tried to make access an executable with no luck.  Teeka if you find an answer let me know I will be very grateful.

Access doesn't run on Mac, and has never been released on Mac, and I'm pretty sure will never be.  The only way your boss could see data from an Access database is via a web interface that connects to Access -- just like the website you're seeing right now.  Richard does everything on Access -- this website, these forum posts, etc., are all stored in Access.  Anybody that has a web browser on their device has no problem using this website.  But yes, designing a website like this is hard work.

This is why a web interface should be on any developer's and/or business owner's game plan due to its universality.

Could they RDP to a windows machine?
Get started with the macOS client

'-
VirtualBox and install a licensed copy of Windows then share the db like you have.
'-
Do they just need access to the db tables?
You could use a Mac equivalent of SSMS
These are paid for, I've used them a few years ago and they work well.
https://www.sqlprostudio.com/
(https://www.macsqlclient.com/)

MS released a db connector app, much like VSCode, but I can't find it.
Instead you could use VSCode with an ext.
- SQL Server extension for Visual Studio Code

Access Online

Juan you can get some exes to run on a Mac using Wine but it wouldn't for work for an access db as you'd need the runtime too, which would prob won't work. Never say never but I wouldn't want to waste my time trying.

Thank you all for your input!  I've already suggested he RDP to a windows box but thought I'd check to see if anything else is out there for MAC users to access Access.  LOL! He needs to have the App front end not just the SQL table data since there is much automation through the forms / buttons, etc.  I think I'll reiterate the jumpbox idea for now and embark on a web front end.  This should be fun!

I use virtual box on my linux machines. Package it up and then distribute as needed. Since storage space isn't an issue these days, i find this be the most convenient option. Unlike RDP, you don't need a separate computer running or even internet access. It's also the easiest to set up and maintain of all the proposed options

Just FYI... my website used to actually run on an old MDB file but I upgraded the back-end to SQL Server about 10 years ago. :)

This topic STILL comes up from time to time. Someone just emailed me today asking about running Access on a Mac. I pointed her here and I asked ChatGPT about it. Here's what it told me. NO, I have not tested ANY of these solutions:

Microsoft Access is not natively supported on macOS. However, there are several methods to run Access on a Mac if you need to use it. Here are some of the most common options:

----

Microsoft Access is not natively supported on macOS. However, there are several methods to run Access on a Mac if you need to use it. Here are some of the most common options:

1. Virtualization Software
   - Parallels Desktop: This is a popular choice for running Windows applications on a Mac. It allows you to create a virtual machine (VM) that runs Windows, enabling you to install and use Microsoft Access as you would on a PC.
   - VMware Fusion: Similar to Parallels, VMware Fusion allows you to run a Windows VM on your Mac, giving you access to all Windows applications, including Access.
   - VirtualBox: This is a free alternative to Parallels and VMware Fusion. It also lets you create a Windows VM, though it might not offer the same level of performance or integration with macOS.

2. Boot Camp
   - Description: Boot Camp is a built-in utility on macOS that allows you to partition your hard drive to install Windows alongside macOS. You can then boot into Windows and run Microsoft Access natively.
   - Considerations: You will need to restart your computer to switch between macOS and Windows. This method provides better performance than virtualization but requires more setup.

3. Remote Desktop
   - Description: If you have access to a Windows PC or server with Microsoft Access installed, you can use a remote desktop application to access that machine from your Mac.
   - Software: Microsoft Remote Desktop is a free app available from the Mac App Store that lets you connect to a Windows PC remotely.

4. Third-Party Alternatives
   - CrossOver: CrossOver is a compatibility layer that allows some Windows applications to run on macOS without a full Windows installation. It supports various versions of Microsoft Office, but compatibility with Access can vary.
   - Considerations: While this can be a convenient solution, it may not support all Access features or versions.

Conclusion

While Microsoft Access doesn't run natively on macOS, you can still use it through virtualization, Boot Camp, remote desktop solutions, or by using third-party alternatives. The best choice depends on your specific needs, such as performance requirements, cost, and how integrated you want Access to be with macOS.