Connecting to database

I'm trying to connect to a database...

I am using a page called connect.asp  which has the following code..

<%
'Option Explicit
Dim myConn, myDb, rs, rs2, sql
Set myconn=server.createobject("ADODB.connection")
mydb = "Driver={Microsoft Access Driver (*.mdb)};DBQ=srp.mdb"
myconn.open mydb
set rs = server.createobject("ADODB.Recordset")
set rs2 = server.createobject("ADODB.Recordset")
%>

The DB is in the same folder as the page, is this right? or is there another code I can use..?

many thanks in advance.. 

sweet i sorted it with the Guest book tutorial..

<%
'Option Explicit
Dim myConn, myDb, rs, rs2, sql
Set myconn=server.createobject("ADODB.connection")
mydb = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("srp.mdb")
myconn.open mydb
set rs = server.createobject("ADODB.Recordset")
set rs2 = server.createobject("ADODB.Recordset")
'This page enables us to specify the whereabouts of the database by simply writing one line on each page.  It means that we can change the location of the database easily by changing its address on this page only.
%>

cheerz..