MDB File Extension


File Type Microsoft Access Database
Category Data Files
Common? Yes

File Description Database file created by Microsoft Access, one of the most widely-used database programs; contains database content as well as tables, forms, queries, etc.

Included with some Microsoft Office software packages, but only available for Windows.

Please CLICK HERE to read more.


How do i import my CSV File

Please read the following as to how to import
your downloaded file into PMD.

Please READ HERE to read how to import a CSV into PMD



Other Information

MDB File Extension

Microsoft Office Access 2007 creates files in a new file format that cannot be opened with earlier versions of Access. This article describes the new features of the Office Access 2007 file format, reviews some issues that arise when you convert to earlier file formats, and summarizes how some related file types have changed from earlier versions.



New features of the Access 2007 file format
In Office Access 2007, the Microsoft Jet database engine (Microsoft Jet database engine: The part of the Access database system that retrieves and stores data in user and system databases. It can be thought of as a data manager upon which database systems, such as Access, are built.) has been customized for 2007 Microsoft Office system programs. This Office-specific version of Jet, called the Access Database Engine, enables integration with Microsoft Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007 and creation of multivalued lookup fields and makes other improvements.

Multivalued lookup fields Most database programs, including earlier versions of Access, allow you to store only a single value in each field. In Office Access 2007, however, you can create a lookup field that allows you to store more than one value in each field. In effect, Access creates a many-to-many relationship within the field and hides the details of the implementation by using system tables.

For example, suppose you have a Task table that contains a lookup field that you use to assign tasks to employees. What if you need to assign a task to several employees? In earlier versions of Access, you must set up a new cross-reference table to store each combination of task and employee and then revise your forms and reports to use the new data structure. In Office Access 2007, a multivalued lookup field makes this process much easier. Items are no longer grouped in a drop-down list. Now each item in the list has a check box next to it, so that you can select as many items as you want. Multiple selections are displayed in the field, separated by commas.

Find links to more information about multivalued lookup fields in the See Also section.

Attachment data type Use the new Attachment data type to easily store all types of documents and binary files in your database without unnecessary database bloat. To maximize space usage, attachments are automatically compressed when it is appropriate. For example, you can attach a Microsoft Office Word 2007 document to a record or save a series of digital pictures. You can even have multiple attachments to a single record.

Find links to more information about attaching files to records in the See Also section.

Integration with Windows SharePoint Services 3.0 and Office Outlook 2007 In earlier versions, Access files are blocked from Windows SharePoint Services and Outlook because unsafe code could be included in an Access database. Office Access 2007 implements a new format that allows code to be either verified as safe or disabled. This feature makes it possible to integrate Access databases much more fully with Windows SharePoint Services and Office Outlook 2007. It also allows antivirus programs to inspect Access database files much more easily.

Offline data You can take your SharePoint lists offline with one click by using Office Access 2007. You can work on your data in Access and then synchronize your changes, or reconnect with the SharePoint site at a later time.

History tracking for Memo fields Memo fields are useful for storing large amounts of information. In Office Access 2007, you can set a property (AppendOnly) that forces Access to retain a history of all changes to a Memo field. You can then view a history of those changes. This feature also supports the versioning feature in Windows SharePoint Services 3.0 so that you can use Access to track changes in a "multiple lines of text" field that is stored in a SharePoint list. The field must have the Append Changes to Existing Text option set to Yes