MDB Admin allows you to open, visualize and edit MSAccess databases (MDB or ACCDB files) without having Access installed.
You can also install MDB Admin using winget:
winget install --id=MarcielDegasperi.MDBAdmin -e
IMPORTANT: To work with .accdb files you must manually install "Microsoft Access Database Engine Redistributable" 32bits, which can be found at the link below:
https://www.microsoft.com/en-us/download/details.aspx?id=54920
(please make sure to select 32-bit version).
==================================
Would you like to contribute to this project by translating it into your language? Download the sample file below, translate the keys and send me via ticket or email. You don't need to know any programming languages for this. :)
https://sourceforge.net/p/mdbadmin/code/ci/master/tree/lang/base_translation.txt
Features
- Open a existing database or create a empty file.
- Compact (and repair) databases
- Create, drop or edit tables, views, procedures, indexes and keys.
- Execute SQL commands (DDL and DML).
- Export tables in differents formats (XML, JSON, CSV, SQL, YAML).
- Dump a entire MSAccess database into a SQL file. You can choice the SQL dialect (MSAccess, MSSQL, Oracle, MySQL, PostgreSQL or SQLite).
- Recover last queries runned.
- Export a MSAccess database as a XLS worksheet.
- Generate a HTML documentation from database.
- Use a GUI interface to easily write SQL queries.
- Easily convert between MSAccess formats (MDB and ACCDB).
- Multiple languages (English, Portuguese, Chinese, Italian, German, Spanish, Hindi)
Follow MDB Admin
User Reviews
-
Splendid utility that saved my day when doing som data archeology.
-
Great tool to administer legacy MDB projects. FAST and friendly w/o MS bloat! WELL Done!
-
Thank you for writing such a great utility!
-
Is a good project