VB+ACCESS2K, WHY I CAN'T INSERT?
INSERT INTO TO_HDR(TO,TRANSWAY,ORDER_TIME) VALUES('SHADR040904001','R','191010')
table fileds:
TO ,TRANSWAY, ORDER_DATE, ORDER_TIME
RETURN ERROR:
INSERT INTO STATEMENT WRONG.
BUT,this insert statement can be executed in ACCESS2K QUERY.
My connection is:
.Provider = "Microsoft.Jet.OLEDB.4.0;"
datasource = "\\192.168.88.32\C$\Glovia_support\WBU\PROJECT\prones1.0\DBFILE\TRANSPORT.MDB"
Thanks!
问题点数：0、回复次数：3Top
1 楼danielinbiti（金）回复于 2004-09-04 20:06:46 得分 0
插入语句怎么执行的？Top
2 楼dflbin（大飞龙）回复于 2004-09-04 20:14:47 得分 0
Set Cmd = New ADODB.Command
With Cmd
.ActiveConnection = cn
.CommandType = adCmdText
.CommandText = strSQL
.Execute
End With
cn is activeconnectionTop
3 楼liuxiaoyi666（MSMVP 小猪妹荣誉马甲之八卦兔子）回复于 2004-09-04 21:58:55 得分 0
你看看你的数据库的文件夹是否为只读Top
