Access Viewer?

J

John

Is there a free Microsoft Access software we can use to "view" MS Access
database? I know there's an Excel/Word viewer. 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.

Thanks.
 
A

Albert D. Kallal

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
 
J

John

Thanks to all for your reply.

I suppose I can use Access 2002 or 2003 to setup the db, is that correct? Is
there any good article on this topic? Thanks again to all of you.
 
J

John

If I'm not mistaken the db is in 2002 (or older) format. I'll take a look at
the link below. Once again, thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top