Can I install Microsft access on Apache server?

A

Anant

I was trying to install a PHPBB2 application on the apache server with MS
Access at the backend. Is this possbile. Is apache compatible with MS
products?
 
A

Albert D.Kallal

Apache does run on a windows box, and so does ms-access. So, I see little
problem as to installing ms-access on the apache server.

We are talking about a windows box however.

As for Apache compatibility with ms-access, you likely would have to ask the
Apache people. Assuming that Apache supports industry standards like ODBC,
then you should be fine. (ODBC = Open Data Base Connectively, ODBC is a open
standard that Microsoft pushed very hard for many years ago, and is now the
standard by which all databases can be connected to.). Sybase, Oracle, sql
server, Mysql etc. ALL SUPPORT THIS standard pushed my MS (and the rest of
the industry).

However, you likely are being confused by ms-access which is a developers
tool like VB, c++ etc. It is not clear if you are looking to install a
developers tool here, or you are looking to use a database with apache?

Remember, VB, or C++ or ms-access is NOT a database. Ms-access is a
developers tool that lets you connect, or use a database of your choice.
ms-access can be used with just about any database in the market place.
There is the native JET database that *most* use with ms-access. When
people use a web server like Microsoft's Internet services, they DO NOT as a
rule install ms-access on that server. They may certainly install the JET
data engine that many (most) use with ms-access, but the requirement to
install ms-access is rare need. So, you can use ms-access to connect to
MySql, Sql server, JET etc.

However, like VB, or C++, ms-access HAS NOTHING to do with creating web
pages. You can can't create a form in MySql. You can't create a report in
MySql. However, ms-access lets you create a user interface (as does VB, or
c++). So, ms-access is a windows based tool to create forms etc, and this
tool really has nothing to do with creating web based systems (no more then
does c++, or VB). So, don't confuse the issue of a software developers tool
like VB or ms-access, and that of needing a database for your web server (we
are talking about two un-related systems, and concepts here.

So, likely, you are not really asking if you can install ms-access on the
web server, as what good does it do? To read mdb files on your web server,
you only need to install the JET data engine. And, by the way, even MS does
not recommend that engine for web servers.
 
Top