UPDATE...
What I decided to do is create an example site for you using Dreamweaver and an Access DB named the same as yours.
I've also used the same folder location for it, "_database" .
In Dreamweaver the best thing for your account here will be to have two connection strings.
One for local testing and development, the other for the live site.
From the Dynamic section of the toolbar you can connect to any connection strings you place in the /connections/ folder.
For the example site attached I've created one for your local testing and one for the remote site.
(Listed below)
The conn string for local testing uses a physical location for the database. (Local drive)
Forthe live,remote, site I'm using the Server.MapPath method. (Very handy)
Local: (/Connections/conn.asp)
[quote]
<%
Dim MM_conn_STRING
MM_conn_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\sdknuts0\_database\customerDetails .mdb"
%></CODE>
Remote: (/Connections/Conn2.asp)
[quote]
<%
Dim MM_Conn2_STRING
MM_Conn2_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/_database/customerDetails.mdb") & ";"
%></CODE>
In the first conn string, Local, my local site folder is c:\sdknuts0\.
That can be any physical location you prefer in Dreamweaver.
This is the code for the recordset I created from Dreamweaver using the Dynamic toolbar features:
[quote]
<%@LANGUAGE="VBSCRIPT ('%@LANGUAGE="VBSCRIPT')" CODEPAGE="1252"%>
<!--#include file="Connections/conn2.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Conn2_STRING
Recordset1.Source = "SELECT * FROM tblPages"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 10
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ADO RecordSet</title>
</head>
[b]
<div>
<table align="center" border="0" cellpadding="4" cellspacing="4">
<tr><td align="left"><u>Customer</u>:</td><td align="left"><u>Details</u>:</td></tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<%="<tr><td align=""left"">&#8226; " & (Recordset1.Fields.Item("Customer").Value) & "</td><td align=""left"">" & (Recordset1.Fields.Item("Details").Value) & "</td></tr>"%>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
</div>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
</CODE>
And this is the example page using all of that code, the remote conn string listed above and the same Access Database:
http://sdknutsnet0.web148.discountasp.net/rs.asp
Using Dreamweaver it took about 10 minutes to create the conn string and all of the code...
Because the dynamic features do most of the code/work for you.
The sample site is attached, code and database.
Hope this helps,
Mark Wisecarver aka wisemx
Post Edited (wisemx) : 8/2/2008 8:21:09 PM GMT