Hi
I am designing a property website and am have designed a database in access 2010 and saved it as a mdb format and am trying to connect to it and display the data
I am using asp to connect to it but is not working
The coding is below
Code:
<html> <head>
<title>Retrieve data from database </title>
</head>
<body>
<%
' Database connection - remember to specify the path to your database'
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER = {Microsoft Access Driver (*. mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath ("/cgi-bin/listofproperties.mdb")
Conn.Open DSN
' Close the database connection
Conn.Close
Set Conn = Nothing
%>
</body>
</html>
could really need the help
Thank you in advance
Ian