[lasasha16]

I would appreciate any advice! I am working with an Access 2000 database that holds ozone data. I need to be able to pull data from the database and display it on a web page. I am currently using Dreamweaver. (Previously, we were doing this via IDC connectors but now want to use ASP.) I need some advice or step by step directions please. I don't know where to begin to connect the two.


Thanks in advance!

[EvilHaider]

If you have dreamweaver installed, simply go to the help pulldown menu and select tutorials. The tutorials that come with Dreamweaver are fairly comprehensive and easy enough for the absolute beginner to follow. It will show you exactly how to go about connecting to an Access database and displaying the data on your ASP pages. You can also visit macromedia.com and go to the dreamweaver 'developer center' which has some additional tutorials. That should be all you need.

[traceMe]

u need to make a connection object that connects to the database throug asp. i.e
<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Provider=Microsoft.Jet.O LEDB.4.0;Data Source="& Server.MapPath("/dynamic/dbhvac.mdb")'this access was in my c:inetpub/wwwroot/dynamic
objConn.open
%>
use the above code to make the connection object then make recordset object
<%set rs=server.createobject("ADODB.Recordset")
rs.open"select * from tablename",objConn,0,2
%>
now use whatever way you want it

I hope this works for you

[TellMe]

I think u R$ u working on dreamweaver with defining a site? If u haven't define a site, define a site using the server technology u use. This may help u.

[Mikeirv]

Just a variation on Traceme's post:

The way he did it will work, however, the recordset that he is using is a slow type. If you need an indexed recordset, that is fine, but if you are just blasting through records, I would do it like this.

<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Provider=Microsoft.Jet.O LEDB.4.0;Data Source="& Server.MapPath("/dynamic/dbhvac.mdb")'this access was in my c:inetpub/wwwroot/dynamic
objConn.open
%>
use the above code to make the connection object then make recordset object
<%
sql = "select * from tablename"
set rs=objConn.execute(sql)
%>