Connect to MS Access DB on the server

I'm trying to connect to my MS Access database from an .aspx page and would sincerely appreciate help with checking this code obtained from the Discount ASP.Net knowledge base article titled "Query an Access database with ASP using a DSN-less conection". My database path is: http://www. mysite.com/_database/Nwind.mdb. My question: Is this code correct? Where should I place the code between the declaration <% %>? Should the <table border="1"> tag be placed between the content placeholders?
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
' DSNLess
cnnSimple.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; Server.MapPath("_database\Nwind.mdb"))
Set rstSimple = cnnSimple.Execute("SELECT * FROM Customers")
%>
<P> Connecting to Access with Ole connection </P>
<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields(0).Value %></td>
<td><%= rstSimple.Fields(1).Value %></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>
<%
rstSimple.Close
Set rstSimple = Nothing
cnnSimple.Close
Set cnnSimple = Nothing
%>

 

Thanks Bruce,


I'll make the changes and follow your advice.

 

When you say:


The table tag should NOT be within the loop, you want to create 1 table w/ each row of data returned from the query displayed as a single row.


Could you give me an example.


Thanks.

 

I think Bruce was talking about your HTML table in the loop, but it does look correct so maybe he was in a hurry.
The loop you have there will create a row with two records side by side until the last DB table row is reached.
Salute,
Mark

 

Thanks Mark,


I sincerely appreciate your quick response.