I agree that Microsoft Access is quite happy to serve as a database for smaller web sites. It doesn't like many more than about 50 concurrent users and you need to ensure that there are weekly maintanence jobs that repair and compact the database as Access has a habit of consuming space quickly. ASP is the primary scripting language when it comes to using Microsoft Access as a database because it can use both ADODB and ODBC to connect to the database. JSP (Java Server Pages) and PHP can also connect to Microsoft Access using ODBC. Once the ODBC connections are set up you have to use SQL to query and update the database.
Answers & Comments
Verified answer
What happens when u run the script?
The first thing would be to check your connection details
So create a new empty PHP file which just connects to the database
<?php
$link = mysql_connect($host,$user,$password);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
?>
and see which appears.
Also check that the mysql libaries are installed by running a phpinfo()
eg
<?php
phpinfo();
?>
I agree that Microsoft Access is quite happy to serve as a database for smaller web sites. It doesn't like many more than about 50 concurrent users and you need to ensure that there are weekly maintanence jobs that repair and compact the database as Access has a habit of consuming space quickly. ASP is the primary scripting language when it comes to using Microsoft Access as a database because it can use both ADODB and ODBC to connect to the database. JSP (Java Server Pages) and PHP can also connect to Microsoft Access using ODBC. Once the ODBC connections are set up you have to use SQL to query and update the database.