Open and View Access Database using MDB Viewer

Have you ever needed to open, edit, or modify a Microsoft Access database file (MDB), but you didn’t have Microsoft Access on your computer? Microsoft has programs to view Word documents, Excels spreadsheets, and Powerpoint files without having the original software installed, however, they do not have this option for MS Access!

Who knows why, but it’s definitely annoying because there are lots of people that use Microsoft Access databases, but not everybody has that installed on their PC. Also, some version of Office, like Student and Basic don’t even have Access as an option to install.

MDB Viewer Plus is a nifty freeware program to view Access database (MDB) tables and records without having Microsoft Access installed. But this is not just an MS Access viewer, it also lets you edit, filter, sort, and search MDB files! That’s sweet!

access viewer

Here are some of the cool features of this program and why every IT Admin should have this program on their USB stick. That’s right, this bad boy runs as a standalone EXE file, so you can open and edit MDB files from any computer.

  • Inline table editing and viewing
  • Supports Access 2000, Access 2003, Access 2007 Accdb files (Must have Microsoft Access database engine 2007 installed, which is a free download)
  • Sort records, filter records, and standard record search
  • Info on table types, table structure and table fields. Ability to print out table structure also.
  • Ability to write standard SQL select statements to query for specific data
  • Ability to export table or SQL query data to TXT, HTML, XML, XLS, DBF, RFT and PDF

This program is basically a mini database development solution, considering you can write queries, edit records, add records, filter and sort records, and even write stored procedures!

The only thing you have to do in order to use this program is to make sure you have Microsoft Data Access Components (MDAC) installed on your PC. This is usually already the case with most Windows operating systems, but if not, you can click on the download link above to install it.

Overall, it’s a good tool for any IT person because you never know when someone will send you an Access database file that you can’t open because you only have SQL Server installed on your machine thinking you would never have to open a MDB file in your life! Enjoy!

Comments [3]

  1. I know it's an old post but….you saved my life! This beauty exporting to XML was exactly what I needed.

    Wish I could buy a beer to whoever coded this!

  2. This freeware is a must have for those who do not want or need Access for development. It does require Microsoft Office Access database engine 2007 (aka 2007 Office System Driver: Data Connectivity Components) which we found here:

    For Access 2010, you can use the "Microsoft Access Database Engine 2010 Redistributable" instead: (Bottom of page)

    I'm with Bruno; this is worth paying for, or at least I would buy this developer a beer! LOL

Leave a Reply

Your email address will not be published. Required fields are marked *