Access and ASP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I, without huge ASP knowledge, convert a Access query into an ASP page?
Thanks for your quick reply.
 
"Without huge ASP knowledge", but some necessary basic knowledge of what ASP
page is and how it works (:.

Basically, you cannot directly "convert" a query to ASP page. you need to
use an appropriate data access technology, most likely it is ADO in ASP, to
get data from the Jet database into a ADO.RecordSet or an Array, and then
present it in the *.asp page. With ADO objects, you can execute dynamic SQL
statement or execute the queries in the Jet database.

BTW, Jet database may not be suitable to your mission critical and/or high
volume trafic web application.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

log history of Access record changes,updated through a FrontPage A 2
Asp and access problems 3
Tool for converting Access Queries & Forms to ASP for Web ? 4
ADO + Connection + Transactions + Access + ASP 4
Access database locked up 4
Using ASPs 2
Connecting from asp to a microsoft access database. 15
Converting Access application to the web 5

Back
Top