Editor for Access Database

Developer: Qiang Li

Current Version: 2.1.0

Last Updated: 1 year ago

Download Size: 12.5 MB - Download


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.

This App also available for iPhone and iPad, you can use iCloud Drive to transfer database from your Mac to your iOS devices.

Support Access Database Version:
- Microsoft Access 2000
- Microsoft Access 2002
- Microsoft Access 2003
- Microsoft Access 2007
- Microsoft Access 2010
- Microsoft Access 2013

- Support mdb and accdb Microsoft Access database format.
- View table data with paging list
- View photo in the database
- 10+ data view UI control (include Map, Date Time, Checkbox, Rating, Color, Dropdown, Multi-select ...)
- Html View with customisable template, you can build beautiful reports with your template
- Filter/Search table data on column
- Sort table data by click on the column header
- Choose tables to show and columns to show
- Drag drop rearrange column order and change column width in main table
- Sow cross table data value by ID ( use the Data Picker Setting )
- Zoom data via change data font size
- Open MDB(Jet) format Access Database
- Open accdb format Access Database
- Full screen support
- Export table data to CSV format with many options
- Export table data to Insert SQL, support access,mysql,sqlite,oracle,postgresql,sybase.
- Export database schema (DDL), support access, mysql,sqlite,oracle,postgresql,sybase.
- Big database support, tested on 300MB size database, table rows over 2 million
- Works great with companion mobile app 'Access Database Manager' for iPhone and iPad

'Edit Data' Features:
- 10+ data edit UI control (include Map, Date Time, Checkbox, Rating, Color Picker, Dropdown, Multi-select ...)
- Update table row data
- Delete table row data
- Add table row data
- Cross table ID,Value single or multi-select using the Data Picker

'DB Creator' Features:
- Create Database
- Create Table
- Create contacts table by import Contacts
- Import CSV data to table or append to existing table

'Map View' Features:
- View Geolocation on map
Support two format:
1. Latitude and Longitude column data;
2. any column contain this format geolocation: {lat:11.123,lng:34.56}
- Auto update Geolocation by search address
Select address column to search, and select save to column to save the found geolocation.
Please select the column which have enough length to save Latitude and Longitude.

'Html View' Features:
- Html View Data
- Customisable Template
- Save Template
- Save the result Html to file ( Then you can print it or email it )
- Sample template Pie Chart, Line Chart, Bar Chart included

'Instant Web Server' Features:
- Publish Access data on local network with one single click, view and add data on any web browser from mobile devices or computers
- Easy setup template for list page and detail page
- Build-in form to add data
- Configable URL Path, template and server port
- Build-in 10+ Html Table Template

If your database don't have password, but still can't open, it maybe encoded. You can use MS Access feature 'Encode/Decode database' to decode it, then open with our App.


Release Notes:

- App Icon updated with iOS version.
- Localize to Chinese Simplified and Chinese Traditional.
- Fix Bugs: Import CSV error, Save Query didn't show control.


Most Helpful Reviews

Version 1.5
Review by Jadeling Hawkins

Frustrating and Weak - I would not recommend purchasing the full version of this software. It works *okay* on a very basic level, but editing tables once you’ve set them up, adding information to tables, removing and organizing…basically everything you would actually use this for is wonky. Really, though, the tables are the worst feature. You can’t edit the column names (which sometimes appear out of order or without the names you assigned to them ((‘Column13’ instead of ‘Calgari Score,’ for example))) and once you’ve got a table that didn’t completely trip on its face on its way out of the gate, the data-entry is time consuming as all get out (there is no tabbing over to the next section; entering information requires double-clicking or single-clicking on every single column you want to add to). There is no user assistance available. Opening the ‘user guide’ will reveal a few images that label the already labeled options in the software—there are no tips, tricks, or further information about how to actually use anything. The softare designer’s website claims to have additional help pages available, but the support links do not work. If it were an option, I would uninstall this and put the $30 I spent on it towards software that…y’know…works. Since that’s not an option, I’ll just post this review and keep looking elsewhere. Good luck to the rest of you :)

Found helpful by 13 out of 14 people

More Reviews for Current Version

Version 2.1.0
Review by 哈哈看到不该看路过

Worthless and Horrible! - I don't recommend this app at all! I got trouble reading table as the columns of the imported table messed up. It also causes problem for any export data!!!!!!! Please don't buy it!

Found helpful by 0 out of 0 people