Viewing Files From Access Database

[Lost User]

I got to upload a file now i am trying to view the files data on the database on a ASP site. How do i do that? Thank you..

[allia]

A simple SQL SELECT statement would do. Dim sql sql = "SELECT the_file_field FROM your_database WHERE some_condition" ' Create a RecordSet Object Dim rs set rs = Server.CreateObject("ADODB.RecordSet") ' Retrieve the records rs.Open sql, Connection, adOpenForwardOnly, adLockOptimistic 'write it Response.write rs("the_file_field") Note: you need to open connection, check EOF, close connection. I reffer you to Chris Maunder's [Article on Accessing Microsoft Access databases in ASP using ADO](http://Article on Accessing Microsoft Access databases in ASP using ADO)[^] I live to code.