Mdb tools для windows
This page is woefully out of date. MDB Tools has moved to GitHub. Please update your links to use this address:
The rest of this page remains for historical interest.
The MDB Tools project is a effort to document the MDB file format used in Microsoft’s Access database package, and to provide a set of tools and applications to make that data available on other platforms.
Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others.
Also included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well.
MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4) formats. Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.
For more information check our FAQ and our Installation Guide. Also see our SourceForge Page for forums, bugtracking, CVS, et al.
Source code for MDB Tools is available from CVS at sourceforge. To anon cvs it, do like this (there is no password, so just hit Enter when asked):
Alternatively, you can obtain the 0.5 release or the 0.6pre1 release. And 0.5 RPMs for i386 Linux are available here.
| Mailing List |
There is a mailing list for those having trouble or who are interested in helping or tracking MDB Tools progress. To subscribe go to http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
Here are some resources that may be useful with MDB Tools (Note: Microsoft reorganized and removed some of these, so they are left as an aid to tracking down the new locations, if any).
when this page opens, on the left side, click on books, then microsoft jet database engine programmers guide. There are 13 chapters & 5 appendices.
Here’s a couple of links that talk about the size of some of the objects:
MDB Viewer Plus 2.63

— Откройте файлы MDB и Accdb.
— Открытие таблицы, встроенное редактирование и просмотр.
— Интерфейс с вкладками.
— Стандартный поиск и частичный поиск слова.
— Фильтрация или сортировка записей по полям.
— Печать таблицы и результатов запроса.
— Запись просмотра.
— Количество записей.
— Открытие и сохранение операторов SQL в файл.
— Портативный;
— Экспорт в HTML, TXT, DBF, XML, WKS, XLS, RTF и PDF.
— Импорт из TXT, CSV, XLS, Doc, WQ1, WK1, DB, SAV, MDB, DBF, ADT, ADO, HTM, DAT, XML, WAB и VCS.
— Поддержка Access 2007 Accdb файлов.
— Юникод совместим.
— Создайте новую пустую базу данных.
— Создать, переименовать, удалить таблицу.
— Установить, изменить, удалить пароль.
— Поддержка файлов рабочих групп (MDW).
— Добавить, удалить, переименовать, изменить поля.
— Настраиваемые диалоги отношения многие ко многим.
— Выборочное открытие столов.
— Добавить или удалить индекс.
| Название | MDB Viewer Plus |
|---|---|
| Версия | 2,63 |
| Разработчик | Алекс Нолан |
| Домашняя страница продукта | MDB Viewer Plus |
| Лицензия | Бесплатно (Freeware) |
| Загрузки прошлой недели | 13 |
| Все время загрузки | 4594 |
| Имя файла | MDBPlus.exe |
| Размер файла | 5.3MB |
| Контрольная сумма MD5 | EA28875BD2D1D59813F41E49C2FAE73F |
| Поддержка ОС | Windows All |
| Категория | Бизнес |
Похожие программы
Collectorz.com Movie Collector 19.2.2
Инструмент, который позволит вам легко управлять и отслеживать свою коллекцию фильмов на DVD и Blu-Ray.
ThumbsPlus 10.2.0.4015
Легко просматривать и управлять своими изображениями с помощью этой программы.
Full Customize Address Book 4.37
Создать сложную базу данных, в которой можно хранить контактную информацию, устанавливать напоминания или отправлять SMS.
Mobile Spider 3.85
Легко найти и извлечь телефонные номера с различных сайтов.
EMDB 3.39
Небольшая утилита для отслеживания вашей коллекции DVD.
Notes Keeper 4.0.3.0
Небольшой инструмент, который позволяет создавать и сохранять заметки.
Exportizer Pro 7.1.2
Программное обеспечение, которое позволяет экспортировать данные базы данных в файл или принтер.
Mdb tools для windows
Welcome to the exciting world of MDB Tools! MDB Tools is a set of programs to help you extract data from Microsoft Access files in various settings.
After several years of neglect, MDB Tools is under new management as of 2020. Update your bookmarks and tell your favorite search engine that this is the new address:
A brief history: the last official release (version 0.7.1) occurred in 2016. cyberemissary (whose work this fork is based on) made a release in December 2018 and called it 0.8.2. In September 2020, @brianb moved his repository to the current address, and gave administrative access to @evanmiller, who acts as the present maintainer.
An official 0.9 release is planned for late 2020. Areas of improvement since the 0.7/0.8 days:
- Security / stability / fuzz testing
- Thread safety
- In-memory database API
- GLib is now optional
- Improved ODBC compliance
- Continuous integration with Travis and AppVeyor
- New mdb-queries tool
The rest of this README explains what you can find in the project, how to install it, and how to contribute.
The major pieces of MDB Tools are:
The core library that allows access to MDB files programatically.
Builds on libmdb to provide a SQL engine (aka Jet)
Provides command line utilities, including:
| Command | Description |
|---|---|
| mdb-ver | Prints the version (JET 3 or 4) of an mdb file. |
| mdb-schema | Prints DDL for the specified table. |
| mdb-export | Export table to CSV or SQL formats. |
| mdb-json | Export table to JSON format. |
| mdb-tables | A simple dump of table names to be used with shell scripts. |
| mdb-count | A simple count of number of rows in a table, to be used in shell scripts and ETL pipelines. |
| mdb-header | Generates a C header to be used in exporting mdb data to a C prog. |
| mdb-parsecsv | Generates a C program given a CSV file made with mdb-export. |
| mdb-sql | A simple SQL engine (also used by ODBC and gmdb). |
| mdb-queries | List and print queries stored in the database. |
| prcat | Prints the catalog table from an mdb file. |
| prkkd | Dump of information about design view data given the offset to it. |
| prtable | Dump of a table definition. |
| prdata | Dump of the data given a table name. |
| prole | Dump of ole columns given a table name and sargs. |
| mdb-hexdump | (in src/extras) Simple hex dump utility that I’ve been using to look at mdb files. |
An ODBC driver for use with unixODBC or iODBC driver manager. Allows one to use MDB files with PHP for example.
The Gnome MDB File Viewer and debugger. Alpha quality, moved to mdbtools/gmdb2.
Files in libmdb, libmdbsql, and libmdbodbc are licensed under LGPL and the utilities and gui program are under the GPL, see COPYING.LIB and COPYING files respectively.
First, you must have reasonably current installations of:
If you want to build the SQL engine, you’ll need bison (version >= 3.0) or byacc, and flex.
If you want to build the ODBC driver, you’ll need unixodbc-dev (version 2.2.10 or above) or iodbc.
If you want to build man pages, you’ll need GNU awk.
If you want to generate the html version of the docbook, you’ll need openjade and basic dsl catalogs.
If you want to build the html version of the docbook documentation, you need to set the environment variable DOCBOOK_DSL to the modular dsl translation file. For example, before configure, you need something like:
OR for a complete install (requires bison, flex, and unixODBC):
By default, MDB Tools is linked against the copy of GLib returned by pkg-config. You can point to a different GLib installation using the GLIB_CFLAGS and GLIB_LIBS enivornment variables. Or, you can disable GLib entirely with the —disable-glib flag, in which case MDB Tools will use an internal implementation of GLib’s functions.
configure can be passed any of the following flags to turn on other capabilities. Note that the options —with-unixodbc and —with-iodbc are mutually exclusive.
A list of general options is available in the INSTALL file, and configure —help will give you the list of mdbtools specific options.
Once MDB Tools has been compiled, libmdb.[so|a] will be in the src/libmdb directory and the utility programs will be in the src/util directory.
You can then install (to /usr/local by default) by running the following as root:
Some systems will also need the ld cache to be updated after installation; You can do that running:
If you are interested in helping, read the HACKING file for a description of where the code stands and what has been gleened of the file format.
