John said:
Is there a free Microsoft Access software we can use to "view" MS Access
database? I know there's an Excel/Word viewer.
You can use excel to import data from the access file.
Is there one for Access? If there is, can we use the software to open MDB
files? We don't care about making changes. We just want to open an mdb
file and the forms contained in the file.
Often however in MS access the data by itself is not that valuable, it's the
application that been designed by a developer who built a user interface
with forms, VB code, quires and reports. This type of concept goes WELL
BEYOND the idea of a simple viewer (so we're talking about Mount Everest,
Grand canyon, Large in terms of the difference between this idea and that if
a viewer).
So, you are asking to run an application that's been developed and designed
by some software developer who used MS access as the tool to build this
software.
There is what we call an access runtime system that will allow you to
execute an access application that's been built by someone else. About the
only requirement for using this run-time system is that the original
developer of the application will have to setup the forms and reprots to
launch by themselves when the application is launched. This runtime system
thus does not have the regular MS access interface, but all of the forms,
VBA code and even reports will run just fine using this runtime system (so
to be fair and honest, you could innocence think of this runtime system has
a type of viewer).
As long as the original person who gives you this application has taken the
above into account, then you can well run the application without having
purchased MS access. You simply have to install what is known as the runtime
system, and then when you click on your mdb file, access will be launched.
As mentioned at that point if the original designer of the application set
up some forms and a user interface to auto run when you launch the
application, then the runtime is a viable solution in your case.
You can find the access 2007 runtime and downloaded it for free here:
http://msdn2.microsoft.com/en-us/office/bb229700.aspx