Hi,

I currently have an Access 2000 database and would like to connect it to the web.

Secondly, how do I access the database through a webpage?

What are the requirements and what needs to be done?

Thanks

To make it available to the web, first converty it to "prior version" through the tools menu and convert to previous version. Next, you need to use ado to connect to the database in server side scripting...ex:

<%
  dim sql
  sql = "SELECT * FROM myDBtable WHERE ((myDBtable.oneColumn)="1");"

  set conn = Server.CreateObject("ADODB.Connection")
  DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
  DSNtemp = DSNtemp & "C:\InetPub\wwwroot\databaseFolder\myDB.mdb;"
  conn.Open DSNtemp
  Set rs = Server.CreateObject("ADODB.Recordset")
  rs.open sql, conn, 3, 3

  rs.close
  set rs = nothing
  conn.close
  set conn = nothing

%>

DBQ is obviously where your converted to 1997 database lays on your hard drive tree, and anytime you want to work with the files within the database....inside the connection string use the recordset identifier to pull it up. Let's say you want the first and last name printed to the web page where myDBtable.oneColumn is equal to "1", as declared in the sql statement. then inside the connection string, write this code...

  response.write rs("firstname") & " " & rs("lastname")

where firstname and lastname are the names of the table fields. does that answer your questions? if not, write back and I'll try to make it more clear.

 Sincerely,
     Jim

Do you know any good books about connecting access to web pages, i really need a step by step guide i can follow to design this web that is connected to access. so far i haven't found anything. I would be very grateful for any help you could give me. thanks

Anything you need to know you can find at the web workshop on microsoft's site for free!

http://msdn.micrsoft.com/workshop

If you still cannot find the answers you are looking for...feel free to email me at jimbob550@hotmail.com. I will try to answer your questions as complete and quickly as possible. But do try to learn it first as I usually work constantly and am busy a lot. But I will try to answer any Q's you may have.

  -Ovatvvon

I want to connect ms access 2000 and Visual Basic through dao control. Please tell me where to find the required driver