Screenshots

Description

Open Microsoft Access database on your Mac with this App, you can view data easily with Filter, Sort, Paging, and export data or schema to other databases. With the In-App Purchase feature 'Edit Data' and 'DB Creator' you can even edit it natively on your Mac, create new databases and new tables.

( We have Pro version with all features included: 'Editor for Access Database', you can find iOS version for iPhone and iPad in App Store. )

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

You can view App demo video on our youtube channel at www.youtube.com/user/woiapp

Features:
- Support mdb and accdb Microsoft Access database format.
- View table data with paging list
- 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 Excel file
- 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

In-App Purchase '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

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

In-App Purchase '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.

In-App Purchase '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

In-App Purchase '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

In-App Purchase 'App Builder'
- Build customised User Interface for your database
- Bind database table row data to user control
- Support Rows Table List, Row detail data controls, search field

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.

What’s New

Version 3.2.0

Localization and update App Icon with iOS version.

Ratings and Reviews

3.0 out of 5
1 Rating

1 Rating

Skycrest1 ,

Can’t rate it-don’t have Microsoft Access

This looks like an excellent application, but I should have waited to buy it until I was able to to get the Microsoft Access app on my Mac computer - which I cannot do. I was trying to move a few Microsoft Works 4.0 files (database files e.g. pharmacy records, automobile service records, etc.) from an old Mac computer to a newer one that I use daily. The old Mac still works OK and the MS Works app still works fine, but I don’t know how long either of them will continue to work (plus I just wish I had everything on the newer computer). I have not been able to find an app that can bring those file for use on my newer computer. I certainly should have checked to see if I could use Microsoft Access on my newer Mac, but I didn’t. I do have the updated version of Microsoft Office on my computer, so I thought I would just be able to bring the files into Excel and adapt them into a spreadsheet.

What I am trying to say by writing this “unreview” is, if you are in the same situation as I am, with Mac computers, your first step is to be able to use Microsoft Access on your Mac before purchasing an app to bring your database files from your old Mac to a newer Mac.

RGM1956 ,

Version 3.0 is so much better!

I have been using Access Database Manager for a couple years now. Initially, it was the ONLY program that would oppen my encrypted Access 2002 database files (OpenOffice/Libre Office and everthing else I tried, failed).

At first, it had a lot of bugs. Some of my data was missing or unavailable. The program crashed somewhat regularly, that sort of thing.

However, I do ave to say John Li has been more than gracious when it comes to addressing the bugs. At this point, almost all the problems I had have been fixed with maintenance updates. He has patiently worthed with me to address every single issue. That’s no bull. Thanks John!

dogzipp ,

Lacks an Edit Function. Useless.

So you’re able to create databases and create tables with an in-app purchase. But you have to be careful, since you only get one attempt to create your table structure perfectly just the way you want it, since once the table is created, you cannot make changes to it (or drop tables). And everyone knows, everything is created perfectly the first time around.

Making a way to “create”, but not edit or delete just makes the whole in-app purchase pointless. And there’s no way to preview functionality before purchasing, so I am out $10 and looking for another solution.

Developer Response ,

Hi, this version basic feature is to view/read Access database files, and the in-app purchase feature provide edit/create features. If you want full feature without in-app, you can buy our full feature version ‘Editor for Access Database'.

Information

Seller
John Li
Size
12.6 MB
Category
Business
Compatibility

OS X 10.11 or later, 64-bit processor

Languages

English, French, German, Italian, Japanese, Korean, Russian, Simplified Chinese, Spanish, Traditional Chinese

Age Rating
4+
Copyright
Price
$7.99
In-App Purchases
  1. Edit Access Database Data (Update/Delete/Add) $2.99
  2. Create Database, Create Table, Create Contacts Table,Import CSV data $1.99
  3. View Geo Location on Map, Update Geo Location by Search Address $1.99

Supports

  • Family Sharing

    With Family Sharing set up, up to six family members can use this app.

More By This Developer