Apple Mac Microsoft Access Database

  

UPDATED JUNE 2017: Prices updated and a 6th app added…

I haven’t tried using Access on OS X directly, but from looking at Microsoft Access in AppDB (a compatibility list for Wine), it could work on Wine, which runs some Windows software directly on the OS X (macOS) desktop.

Yes you read that correctly! Up until recently, there was no way to open a Microsoft Access database directly on a Mac. However, there are, at the time of writing, five apps, all available from the Mac App Store, which allow you to open and view data in Access database tables. Below is a summary of the apps.

  1. If by the same thing as Access, you mean to create a database on the Mac then look at FileMaker Pro 14. It can create a database on the Mac. The database will not be compatible with Access though.
  2. Apple; Mac; iPad; iPhone; Watch; TV; Music; Support; Shopping Bag + Cancel Apple Books Preview. Local Nav Open Menu Local Nav Close Menu. Top Books Top Audiobooks Oprah’s Book Club Database (Microsoft Access 2016) Level 1 Step-by-step Training Manual. $2.99; $2.99; Publisher Description. This manual covers Microsoft Access 2016.

Apple Mac Microsoft Access Database Tutorial

MDB Tool

  • Opens MDB and ACCDB files (2007 only, not 2010/2013)
  • Only provides access to tables. Does not support queries, forms or reports
  • Exports to CSV and SQL formats
  • Available for £5.99 from https://itunes.apple.com/gb/app/mdb-tool-for-microsoft-access/id513995545?mt=12

MDB Explorer

  • Opens tables from multiple databases at same time
  • Exports to various formats including CSV, TXT, Excel and SQL
  • Filter, sort and search functionality allows you to easily find the information you need
  • Supports MDB but ACCDB support is available via in-app purchase £9.99
  • Available for £9.99 from https://itunes.apple.com/gb/app/mdb-explorer/id506622388?mt=12

MDB ACCDB Viewer

  • Opens MDB and ACCDB files
  • Search functionality
  • If you double click a record it opens in a separate window – great for reading long text entries
  • Exports to various formats including Excel, CSV, SQL
  • Documentation includes instructions for transferring to Bento, Numbers, Open Office
  • Available for £18.99 from https://itunes.apple.com/gb/app/mdb-accdb-viewer/id417392270?mt=12

MDBLite

  • Converts MDB to SQLite
  • SQLite is a small database engine found in many gadgets and small websites
  • Just drag and drop the MDB file onto the app’s window
  • Supports MDB format only
  • Available for £3.99 from https://itunes.apple.com/gb/app/mdblite/id487704620?mt=12

ACCDB Explorer

  • From the same company that makes MDB Explorer
  • Similar functionality to MDB Explorer but supports ACCDB as well as MDB
  • Reads attachments from 2007 format databases
  • Reads calculated fields from Access 2010 format databases
  • £19.99 from https://itunes.apple.com/gb/app/accdb-explorer/id577722815?mt=12

Viewer for Access Database

  • I have added this one following an email I received from the developer (Disclaimer: I am NOT making any money from this!)
  • At this time the app supports to open, view and export accdb and mdb files.
  • The developer will improve the app on user request in the next weeks/li>
  • £2.99 from https://itunes.apple.com/gb/app/access-database-viewer/id1241742780?mt=12

Apple Mac Microsoft Access Database Access

Editor for Access Database

Gta liberty city iso for ppsspp. The only Mac App which allow you edit MS Access Database on Mac directly. View, Edit and Create Microsoft Access database on your Mac with the App. You can view data easily with Filter, Sort, Paging, and export data or schema to other databases, also edit data directly with very customizable data control, create new databases and create new tables.

How to easily, efficiently and with no re-coding run Microsoft Access on a MAC

The picture opposite was reproduced from Microsoft’s pricing page for Office 365. The point to highlight is the text below the Access icon saying: “PC Only”. Microsoft don’t do a version of Access for Mac or iPad or even Android tablets.

Chances are if you’ve developed an Access database application then you have a Windows PC anyway, so what’s the issue?

Well, what if you need to share your Access application with colleagues, and what if those colleagues are using a Mac or other non-Windows device? What if your boss wants to check something from his iPad at home?

The answer actually solves two problems. The best way to share an Access database application with Mac users is also one of the best ways of sharing an Access database application full stop. The solution is to use a hosted remote desktop service.

Access on a remote desktop

Microsoft have developed a Remote Desktop Client for Mac, iOS and Android, as well as Windows. This means that if you run your Access database from a Hosted Desktop it can be used by users of any device just as easily as those running Windows.

Mac Microsoft Access

What is a hosted remote desktop service?

Remote Desktop Services, previously called Terminal Services is a technology that enables applications to be run on the remote desktop server instead of the user’s PC (or Mac). Lots of users can log on to the remote desktop server and run the same applications simultaneously. The system was designed mainly to help organisations with remote sites that needed to run applications where the data, documents or databases are at a central location. It’s a bit like having really long keyboard, mouse and monitor cables.

With the recent improvements in internet speed as well as other technologies such as server virtualisation it is now easy to host the Access database with a service provider rather than pay to build and maintain the technology yourself.

Benefits to a hosted remote desktop service

Beyond the ability to run Access on a Mac or iPad, hosting it gives you a number of other benefits:

  • The remote desktop service is supported and maintained by the provider
  • Your data is backed up
  • You can run your Access database from anywhere in the world where there is an Internet Connection
  • Users running Access on a Mac will get the same experience as users running it on their PC
  • There are no code changes required as Access is, in reality, running on a Windows machine
  • You can use the Access Runtime environment so no Access licence costs
  • Flexibility to increase or decrease user numbers
  • Scalability to increase user numbers to the maximum supported by Access

Contact us to get your Access database hosted in the cloud

You can see that running your Access database on an iPad or Mac or easy and effective using hosted remote desktop services. To find out more about how to get your Access database in the cloud to run on a Mac contact one of Your Office Anywhere’s technical sales consultants who can discuss your individual requirements and provide you with a demonstration. Call today on 01282 500318 or complete the form at our contact page.

Contact us here for a fast response

Call Us

Office

Your Office Anywhere, 4 Dominion Court, Billington Road, Burnley, BB11 5UB

Access On Mac

Hours (Sales)