What's new in MDB ACCDB Viewer
MDB Viewer no longer crashes when an error occurs during export to XLS or XLSX.
An apropriate error message is displayed instead.
Fixed a memory access error that might cause a crash in rare circumstances.
Add support for MacOS 10.12 Sierra.
(Unfortunately this required dropping support for 32bit Macs.)
Fixed a rare crash due to a memory error.
New XLSX export:
I completely rewrote the XLSX export code. Exporting to XLSX format should now be faster and use much less RAM.
The new export code also fixes an issue where control characters in text fields would result in invalid XLSX files.
Last but not least, the new code is smaller, so MDB Viewer downloads quicker.
Fixed a crash that occurred when the database contains a special type of hyperlink field.
Fixed PostgreSQL export:
PostgreSQL doesn't support the DOUBLE type, changed it back to DOUBLE PRECISION.
Improved Error Messages:
More detailed error messages when exporting to XLS or CSV format fails.
Fixed Crash on Snow Leopard:
MDB ACCDB Viewer 2.2.2 crashed on 64 bit Macs running Mac OS X 10.6.
The issue was caused by a bug in Xcode 4.6.
I fixed it by using XCode 4.5.2 to build MDB ACCDB Viewer.
XLSX Support: Added support for the newer, XML based Excel format.
Boolean Fields: Handling of Boolean fields has been improved.
The values are now exported as TRUE/FALSE rather than 1/0 (except SQLite, which doesn't support TRUE/FALSE).
When exporting to SQL, the BOOLEAN type is used rather than INTEGER.
DOUBLE vs. DOUBLE PRECISION:
When exporting SQL, MDB Viewer now uses "DOUBLE" rather than "DOUBLE PRECISION" as the data type for floating point fields.
The two types are identical, but a 3rd party application does not support "DOUBLE PRECISION".
Fixed Crash: Fixed a crash when exporting tables with long names to Excel.
The problem was related to the fact that Excel worksheet names are limited to 31 characters.
MDB Viewer now truncates table names accordingly when exporting.
Fixed Crash: MDB Viewer 2.2 could crash when opening files with invalid index metadata.
This problem is now fixed.
New name: I changed the name from MDB Viewer to MDB ACCDB Viewer to better
reflect the capabilities of the app.
MDE & ACCDE: MDB ACCDB Viewer now also supports MDE and ACCDE file types.
the primary key is now also exported when exporting to MySQL, PostgreSQL or SQLite.
Export multiple CSV files at once:
Now you can export multiple tables to CSV at once.
Just select multiple tables in the sidebar (press ⌘ or ⇧ while clicking),
and then click on “Export CSV.”
Additionally you can now conveniently choose to export all tables directly in the Export dialog.
New start up window: the startup window from version 2.0 confused
some customers with the instruction “drop files to open”.
The new version sports a straight-forward “Open Database…” button.
You can still drag files on the window, but this functionality is
no longer advertised.
New Help System: Rather than using the system help browser,
the documentation is now integrated in the application. While
the system help browser offered some convenient functionality,
it was very unreliable: It sometimes failed to find help files.
The worst thing that can happen to a user who wants to look at
the documentation is showing them a message “Help file not found.”
Fixed a problem with CSV export: double quotes inside fields are now
Special floating point values such as “Not A Number” or “Infinity” are
now replaced with NULL when exporting SQL or SQLite.