Hi all,
  I get the following error when i try to insert records into MS.Access Database

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Driver={Microsoft Ac'
/test/savenewuser.asp, line 24

my code is as follow
<%
    dim objConn, objrecordset, strSql
    dim uid, fname, lname, password, email

   uid = request.Form("txtuserid")
   fname = request.Form("txtfname")
   lname = request.Form("txtlname")
   password = request.Form("txtpassword")
   email = request.Form("txtemail")

    objConn = "Driver={Microsoft Access Driver (*.MDB)}; DBQ=C:/Inetpub/wwwroot/test/LogDatabase.mdb"
    set objrecordset = server.createobject("ADODB.recordset")
    strSql = "INSERT INTO tbllogin(userid, fname, lname, password, email) values('"& uid &"', '"& fname &"', '"& lname &"', '"& password &"', '"& email &"')"
      objrecordset.open strSql, objconn
    objConn.close
    set objrecordset = nothing

%>

Thanks in advance

    set objconn = Server.CreateObject("ADODB.Connection")
    objConn = "Driver={Microsoft Access Driver (*.MDB)}; DBQ=C:/Inetpub/wwwroot/test/LogDatabase.mdb"

Also, I always liked this instead of hard coding the path:

    objConn = "Driver={Microsoft Access Driver (*.MDB)};DBQ=" & _
Server.MapPath("LogDatabase.mdb")

Sorry... It should be:

    set objconn = Server.CreateObject("ADODB.Connection")
    objConn.Open "Driver={Microsoft Access Driver (*.MDB)}; DBQ=C:/Inetpub/wwwroot/test/LogDatabase.mdb"

OR:

    objConn = "Driver={Microsoft Access Driver (*.MDB)};DBQ=" & _
Server.MapPath("LogDatabase.mdb")


An aside: Where is the edit post button?

U.N.C.L.E. Thank for the help.

can you tell me if i have to put that connection string in globale.asa, how do i do that?

thanks in advance

You don't have to do that, you can define a global variable with it in it, or use an include file that defines it (latter is popular choice).

It's on the top of each message you posted. It's the third button (the middle one) and has a pencil on it.

Imar


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