Edit and view the Access database mdb File in Ubuntu

Because the database of a website uses the. mdb database type (Access in MS), openoffice does not support editing in Ubuntu. What should we do? Solution: Install sudoapt-getinstalllibmdbtoolsmdbtoolsmdbtools-gmdb. After installation, you can view the MDBViwer menu in the application-office. You can view the menu even if the mdb has a password. Of course mdb

Because a website database uses the. mdb database type (Access in the MS), You want to edit it under Ubuntu, but open office does not.

What should we do? Solution

Installation:

Sudo apt-get install libmdbtools mdbtools-gmdb

After installation, you can view the MDB Viwer menu in the application-office, even if the mdb has a password.

Of course, mdbtools provides the following commands:

Mdb-array mdb-header mdb-parsecsv mdb-schema mdb-tables

Mdb-export mdb-hexdump mdb-prop mdb-SQL mdb-ver

These commands can be directly used to access *. mdb files. For example, mdb-export can easily output data, while mdb-schema can also generate SQL commands for DROP/CREATE TABLE.