Export Table - MDB

MDB refers to the .mdb formats used with Microsoft's Access database products. These formats have been made available in the Microsoft "Jet" database engines (the same used within Access) that may be used royalty-free by developers working with Microsoft development products such as Visual Studio. As a result, many thousands of third party applications can read and write .mdb formats.

 

To export a table to .mdb format:

 

1. Open the table in a table window.

2. Choose File - Export - Table from the main menu.

3. In the Export dialog choose MDB Files in the Save as type box and specify a filename to use. Press Save.

4. Check the fields that are to be exported. Buttons provide for Select All, Select None and Select Inverse to rapidly change which fields are to be exported for tables containing many fields.

5. Check use Access 97 format for greatest compatibility with other applications.

 

Controls

 

Subtype

Choose Access 2000 or Access 97 .mdb format. Note that Access 97 cannot read Access 2000 .mdb format files.

images\btn_box_select_all.gif

Select All - Check all fields. All data fields in the table will be exported.

images\btn_box_select_none.gif

Select None - Uncheck all fields. No data fields will be exported. Tech tip: Use this to uncheck all fields before checking those desired.

images\btn_box_select_invert.gif

Select Inverse - Uncheck all previously checked fields and check all previously unchecked fields. This is a fast way to check only a few columns out of many: uncheck those desired and then push Select Inverse.

Fields pane

Check the fields to be exported.

 

Access 97 and Access 2000 .mdb Formats

 

Until Access 2000, all .mdb capable applications could exchange data without any problems. However, with the introduction of Access 2000 and Jet 4.0, Microsoft changed the .mdb format slightly so that the "new" .mdb cannot be read either by Access 97 or by any applications using Jet versions prior to Jet 4.0. In particular, Manifold System Release 4.50 uses Access 97 format.

 

Manifold's export to .mdb will write to the "new" .mdb by default. A checkbox option allows writing to the Access 97 .mdb format if desired. Since Access 2000 and Jet 4.0 based applications can read the older Access 97 / Jet .mdb formats, a good strategy to assure maximum compatibility with all ".mdb" applications is to check the Use Access 97 format box if the files will be used for interchange, exchanged with Manifold System 4.50 users or otherwise widely published.

 

Important Note when Using 64-bit Manifold Editions

 

Due to a lack of required Microsoft facilities in 64-bit Windows systems, Manifold in 64-bit mode cannot export, import, export or link to DB, HTML, MDB, XLS or WKx format files. This includes no access to the MDB parts of Manifold MFD and MapInfo TAB imports. The workaround for importing or exporting such files is to launch Manifold in 32-bit mode by using the Manifold System (32-bit) shortcut, perform the export from or import into a .map project file and then re-launch Manifold in 64-bit mode using the Manifold System (64-bit) shortcut. Linking is more complex: the data must be in some format usable in 64-bit mode within 64-bit Windows systems, such as a SQL Server database. Alternatively, the data can be kept within a Manifold .map project file and linked using the Manifold ODBC driver.

 

Although Microsoft is slowly moving forward towards 64-bit operation of Office and the JET components used by Access and Excel, at the present writing (2010) this is such a total kludge that while it is possible to get 64-bit access to Access or Excel it is just easier for most to continue using the 32-bit versions. See comments in the 32-bit and 64-bit Manifold Editions topic.