Below is my local database connection code:

'connection to database
set conn=server.createobject("adodb.connection")
set rs=Server.CreateObject("ADODB.Recordset")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/inetpub/wwwroot/database/sample.mdb"

i need to upload my asp files and the database to the internet; what do i need to change so that the code will still work when it is upload?

thanks

have you purchased a webspace to upload your website? Or you have some free webspace? Tell in details where you want to upload this website.

conn.Open "c:/inetpub/wwwroot/database/sample.mdb"

That line will have to be changed to match the path to the database on the web server. I usually use Request.ServerVariables ("SERVER_NAME") to detect the host (localhost vs. web sserver) and handle that line accordingly from there.

conn.open server.mappath("/database/sample.mdb")

You forgot a quote, Hirst.

Fixed.