在dreamweaver中编好ASP与Access数据库连接：
<%
dim conn,mdbfile
mdbfile=server.mappath("数据库名称.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};uid=admin;pwd=数据库密码;dbq="&mdbfile
%>

应该怎样测试连接成功？

<%
for i=1 to rs.recordcount
name=trim(rs("music_chinese"))

response.write"<a target=_blank >"&name&"</a>"

rs.movenext
next

rs.close
set rs=nothing
%>

还是不清楚怎么用。讲清楚一点。放在什么地方/还要加什么吗？

on error resume next

set conn = Server.CreateObject("ADODB.Connection")
str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("fool.mdb")
conn.Connectionstring=str
conn.open
If Err Then
err.Clear
Set conn = Nothing
Response.Write "数据库连接出错，请检查连接字串。"'
Response.End
End If

还有一种办法就是利用con对象自身的属性进行判断如
set conn = Server.CreateObject("ADODB.Connection")
str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("fool.mdb")
conn.Connectionstring=str
conn.open
IF conn.State=1 Then
Response.Write "数据库连接成功"
Else
Response.Write "数据库连接失败"
End IF