-->
Jan 29, 2013 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. 2018-1-15 目前来说,macOS和Microsoft都没有提供一个单独的软件能够像Access for Windows那样的集成化全功能软件编辑Access数据库。根据需求不同,可能可以使用下面的两种方式读取Access数据: 在Mac上第三方的软件一般都是只能读取Access的数据,而不能.
This topic describes how to install, configure, update, and use Microsoft Defender ATP for Mac.
Caution
Running other third-party endpoint protection products alongside Microsoft Defender ATP for Mac is likely to lead to performance problems and unpredictable side effects. If non-Microsoft endpoint protection is an absolute requirement in your environment, you can still safely take advantage of MDATP for Mac EDR functionality after configuring MDATP for Mac antivirus functionality to run in Passive mode.
What’s new in the latest release
Tip
If you have any feedback that you would like to share, submit it by opening Microsoft Defender ATP for Mac on your device and navigating to Help > Send feedback.
To get the latest features, including preview capabilities (such as endpoint detection and response for your Mac machines), configure your macOS machine running Microsoft Defender ATP to be an 'Insider' machine. See Enable Microsoft Defender ATP Insider Machine.
How to install Microsoft Defender ATP for Mac
Prerequisites
- A Microsoft Defender ATP subscription and access to the Microsoft Defender Security Center portal
- Beginner-level experience in macOS and BASH scripting
- Administrative privileges on the device (in case of manual deployment)
Installation instructions
There are several methods and deployment tools that you can use to install and configure Microsoft Defender ATP for Mac.
Third-party management tools:
Command-line tool:
System requirements
The three most recent major releases of macOS are supported.
- 10.15 (Catalina), 10.14 (Mojave), 10.13 (High Sierra)
- Disk space: 650 MB
Beta versions of macOS are not supported. macOS Sierra (10.12) support ended on January 1, 2020.
After you've enabled the service, you may need to configure your network or firewall to allow outbound connections between it and your endpoints.
Network connections
The following table lists the services and their associated URLs that your network must be able to connect to. You should ensure that there are no firewall or network filtering rules that would deny access to these URLs, or you may need to create an allow rule specifically for them.
Service location | DNS record |
---|---|
Common URLs for all locations | x.cp.wd.microsoft.com cdn.x.cp.wd.microsoft.com eu-cdn.x.cp.wd.microsoft.com wu-cdn.x.cp.wd.microsoft.com officecdn-microsoft-com.akamaized.net crl.microsoft.com events.data.microsoft.com |
European Union | europe.x.cp.wd.microsoft.com eu-v20.events.data.microsoft.com usseu1northprod.blob.core.windows.net usseu1westprod.blob.core.windows.net |
United Kingdom | unitedkingdom.x.cp.wd.microsoft.com uk-v20.events.data.microsoft.com ussuk1southprod.blob.core.windows.net ussuk1westprod.blob.core.windows.net |
United States | unitedstates.x.cp.wd.microsoft.com us-v20.events.data.microsoft.com ussus1eastprod.blob.core.windows.net ussus1westprod.blob.core.windows.net |
Microsoft Defender ATP can discover a proxy server by using the following discovery methods:
- Web Proxy Auto-discovery Protocol (WPAD)
- Manual static proxy configuration
If a proxy or firewall is blocking anonymous traffic, make sure that anonymous traffic is permitted in the previously listed URLs.
To test that a connection is not blocked, open https://x.cp.wd.microsoft.com/api/report and https://cdn.x.cp.wd.microsoft.com/ping in a browser.
If you prefer the command line, you can also check the connection by running the following command in Terminal:
The output from this command should be similar to the following:
OK https://x.cp.wd.microsoft.com/api/report
OK https://cdn.x.cp.wd.microsoft.com/ping
Caution
We recommend that you keep System Integrity Protection (SIP) enabled on client machines. SIP is a built-in macOS security feature that prevents low-level tampering with the OS, and is enabled by default.
Once Microsoft Defender ATP is installed, connectivity can be validated by running the following command in Terminal:
How to update Microsoft Defender ATP for Mac
Microsoft regularly publishes software updates to improve performance, security, and to deliver new features. To update Microsoft Defender ATP for Mac, a program named Microsoft AutoUpdate (MAU) is used. To learn more, see Deploy updates for Microsoft Defender ATP for Mac
How to configure Microsoft Defender ATP for Mac
Guidance for how to configure the product in enterprise environments is available in Set preferences for Microsoft Defender ATP for Mac.
macOS kernel and system extensions
In alignment with macOS evolution, we are preparing a Microsoft Defender ATP for Mac update that leverages system extensions instead of kernel extensions. Visit What's new in Microsoft Defender Advanced Threat Protection for Mac for relevant details.
Resources
For more information about logging, uninstalling, or other topics, see the Resources page.
UPDATED JUNE 2017: Prices updated and a 6th app added…
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.
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
Python Os Access
Editor for Access Database
Microsoft Access On Mac Os Windows 7
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.