Friends I'm make data data base with ASP. but still a problem the massage is comming that,


Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\student.mdb'.
/registered.asp, line 26


& the codeing is


<%

'Dimension variables
 Dim adoCon 'Holds the Database Connection Object
 Dim rsAddComments 'Holds the recordset for the new record to be added
 Dim strSQL 'Holds the SQL query to query the database

 Set adoCon = Server.CreateObject("ADODB.Connection")
 adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &Server.MapPath ("student")
 Set rsAddComments = Server.CreateObject("ADODB.Recordset")

 strSQL = "SELECT info.Fname, info.Lname, info.Country, info.City, info.Address, info.Contact, info.Email FROM student.mdb;"

 rsAddComments.CursorType = 2
 rsAddComments.LockType = 3
 rsAddComments.Open strSQL, adoCon
 rsAddComments.AddNew
 rsAddComments.Fields("FName") = Request.Form("Fname")
 rsAddComments.Fields("LName") = Request.Form("Lname")
 rsAddComments.Fields("Country") = Request.Form("Country")
 rsAddComments.Fields("City") = Request.Form("City")
 rsAddComments.Fields("Address") = Request.Form("Address")
 rsAddComments.Fields("Contact") = Request.Form("Contact")
 rsAddComments.Fields("Email") = Request.Form("Email")

 rsAddComments.Update
 rsAddComments.Close
 Set rsAddComments = Nothing
 Set adoCon = Nothing


%>

plz help me in this matter.

Hi there,

There are at least two problems in your code:

1. DBQ=" & Server.MapPath ("student")

You'll need to Map the path of the Entire database, so you'll need to change this to: DBQ=" & Server.MapPath ("student.mdb") where student.mdb is the name of your Access database

2. SELECT info.Fname, etc etc FROM student.mdb

You can't use the database name in a query; instead you need to reference a table:

2. SELECT info.Fname, etc etc FROM student

where student is a table in your student.mdb database.

Are the files for the website located in the root of your C drive?
HtH

Imar




---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.