ASP is not any data entry error code <% Set conn=server.createobject ( "adodb.connection") Conn.open "driver={microsoft access driver (*.mdb) };dbq=" &server.mappath ( "235tel.mdb") Name=request.form ( "name") Sex=request.form ( "sex") Tel=request.form ( "Tel") Exec= "insert into guestbook (name, sex, tel) values ( '" &name& "', '" &sex& "'," &tel& ")" Conn.execute exec Conn.close Set conn=nothing %> # Error types : Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] operation can be used to update an inquiry. /235sub.asp, Line 8 This is how?

Mdb database is the authority, the proposed change in the user complete control attributes

How specific changes?

I have all the authority opened

Http://www.brsky.net/web/index.asp?id=9 See if it is the problem

Exec= "insert into guestbook (name, sex, tel) values ( '" &name& "', '" &sex& "'," &tel& ")" Conn.execute exec Conn.close Set conn=nothing %> The% 〈% ... Exec= "insert into guestbook (name, sex, tel) values ( '" &name& "', '" &sex& "'," &tel& ")" Set rs=conn.execute (exec) %>

Put paper clips stored in the database set up for everyone to control authority

I have tried the above two methods, but he that it was his link HTML documents : "Form name="_ftn1"" form1 "method=" post "action=" 235sub.asp "" "Width= table" 263 "height" 120 "border" 0 "to save the" center "cellpadding=" 0 "cellspacing" 0 "bgcolor=" #0099FF "" "Tr> "Td width=" 71 "height" 28 "=" Name : " "Td width=" 186 "and" <input type= "government" name="_ftn1" "name" and "</td> "Per "Tr> "Td width=" 71 "height" 28 "=" Sex : " "Td><select name="_ftn1"" sex "size =" 1 "" "Option selected> men" /option> "Option> woman" /option> "/select></td> "Per "Tr> "[Passages on congress progress omitted] :" = "Td><input type=" government "name="_ftn1"" tel "value=" "" </td> "Per "Tr save the" center "" "Td height=" 31 "colspan=" 2 "" "Input type=" submit "name="_ftn1"" submit "value=" Submitted "" "Input type=" reset "name="_ftn1"" Submit2 "value=" re-write "and" </td> "Per "ShapeID="_x0000_i1025" DrawAspect="Content" ObjectID="_1127825915"> </o:OLEObject> "/form>

Cdmin said in a message Code is not the problem, your server database file can be written authority of the habits of users liberalized. Directly to the folder where you have a database set up to the safety authority : everyone full control of everything!

In this step, and I have all the security options open Lane authority, in addition to not set up a CREATOR OWNER But not everyone full control of this.

Cdmin said in a message But this operation is shut your windows. Increase users : everyone Then everyone in authority "complete control" of everything tick.

I built everyone, the authority opened But it still can not be read into that 55555

Unknown accounts (S-1-5-21-299502267-261478967-725345543-1003) What does it mean to you? I have never seen this

Exec= "insert into guestbook ([name], [sex], [tel]) values ( '" &name& "', '" &sex& "'," &tel& ")"

Cdmin said in a message Because you are equipped with a number of systems. In addition the user is a system administrator - In addition. Not everyone needs the authority. . You can write everything into the installed user iiis

I have only one XP I attribute all IIS Lane, the authority has opened We can not die

Thank you expert help, I have successfully resolved the problem!

[ Closed window ]