ASP Database access: Access
Using Access with ASP.

• Home
• ›
• Code snippets
• ›
• ASP
• ›
• ASP Database access: Access

A very basic example (kept here for reference) of using Access with ASP.

<% Dim Conn,RS,SQL,DSN DSN = "DBQ=" & Server.Mappath("benchmark.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" Set RS = Server.CreateObject("ADODB.Recordset") Set Conn = Server.CreateObject("ADODB.Connection") ' Start time Response.Write "Started: " & Hour(Now()) & ":" & Minute(Now()) & ":" & Second(Now()) & "<br>" Conn.Open DSN SQL = "SELECT * FROM table" RS.Open SQL,Conn,1,2 Do While Not RS.EOF i = i +1 RS.MoveNext Loop ' End Time Response.Write "Finished: " & Hour(Now()) & ":" & Minute(Now()) & ":" & Second(Now()) & "<br>" Response.Write i & " records found." %>

---

{Name}
Says:

{Date}
{Text}

› Home
› C#
› Snippets
› Articles
› Tools
› Taglines
› ASP
› Dictionary Object
› FSO
› Unix cheat sheet
› Gaming
› CSS
› Yak
› Umbraco
› About
› Contact
› Privacy
› Projects
› Search
› Sitemap