MDB Viewer Plus - The Missing Piece in Access
A few years ago, I was looking for a free MDB Viewer Plus download. And sure enough, there it was... but the software itself was not free! Instead, I got a spyware (also free) program that tried to scare me into buying the upgrade for the software. But I didn't. So, what's the deal?
Actually, there's nothing particularly wrong with MDB Viewer Plus. Microsoft has put out some excellent tools for working with MS Access, as well as working with MDB files. The problem is that some people just can't seem to master the "read/write" behavior of Access, especially when they're working on an MDB file. For example, when you try to create an MDB view from scratch in Access, you have to first open an MDB viewer in your favorite editor, like notepad or outlook, and then select the "rowset" or "view" command, which will bring up the view pane, then you can drag the columns and drop the data you want to move into your custom database. When you then select "row" or "table" to move the data into the specified table, you get the data in the corresponding MS Access table. However, sometimes you need to copy or move data from one view to another view, and this can be very difficult in Access when it comes to editing the data directly in the data model view.
So, what you need is a tool that will let you select "edit" in the data model view, then lets you move the data from your custom data model view into the appropriate view, and so on. There are many such tools available, like Advanced Access Project, Drupel, DataNumen, and many others. You just need to search Google for them. And there's one more thing: in many of these tools, you have to specify the properties of each cell in the view pane so that the data is correctly inserted and placed into the appropriate tables and views. This is why you need a tool that will allow you to easily drag and drop the cells from your custom MDB view into the corresponding tables and views in Access.