oRs.CursorLocation = adUseClient
oRs.Open "SELECT * FROM ZCYZK.DBF", oConn, adOpenForwardOnly, adLockReadOnly
返回E_FAIL错误
必须oRs.Open "SELECT BH,PM,KCS FROM ZCYZK.DBF", oConn, adOpenForwardOnly, adLockReadOnly 具体到列才能成功
去掉oRs.CursorLocation = adUseClient,两者就都可以了,已经记不得为什么要用客户端光标,可能只有这样才能INSERT INTO数据增加到DBF吧。