ASP, SQL 问题

Hanamichi

set conn=Server.CreateObject("ADODB.Connection")
        conn.Provider="Microsoft.Jet.OLEDB.4.0"
        conn.Open "C:\Inetpub\wwwroot\DB\DATABASE.mdb"
       
        sql="INSERT INTO Table2 (Field1) VALUES ('asdasd')"

    conn.execute sql
    conn.close

出现将的error message:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.

请问我的code出现什么问题？

[ 本帖最后由 Hanamichi 于 4-12-2006 03:37 AM 编辑 ]

hooi1983

http://databases.aspfaq.com/data ... e-query-errors.html

Permission 的问题