Tutorials to .com

Tutorials to .com » Asp » Database » Access database table read example

Access database table read example

Print View , by: iSee ,Total views: 15 ,Word Count: 128 ,Date: Mon, 25 May 2009 Time: 10:41 AM

8/30/2001 12:28:41 PM in kendylan add Joy asp ← return to the page:
<%
strConn = "DBQ =" + server.mappath ( "kendylan.mdb ")+"; DefaultDir =; DRIVER = (Microsoft access Driver (*. mdb));"
set objConn = server.createobject ( "Adodb.connection")
objConn.open strConn
set rsSchema = objConn.openSchema (20)
rsSchema.movefirst
Do Until rsSchema.EOF
if rsSchema ( "TABLE_TYPE") = "TABLE" then
response.write rsSchema ( "TABLE_NAME") & "<br>"
end if
rsSchema.movenext
Loop
set objConn = nothing
%>


ASP Database Related Articles


Can't Find What You're Looking For?


Rating: Not yet rated

Comments

No comments posted.