d**t 发帖数: 14 | 1 When I use Addnew method and run my form, the error'91' said: Object variable
or With block variable not set. Could anybody tell me what's that mean and
what should I do?
Thanks a lot!
dgyt
~ |
|
h**********r 发帖数: 174 | 2 Using ADO's RecordSet in Access2000
I have a very simple table with only two fields(byte, text). I want
to use RecordSet to add a row into it by using the AddNew methods. But
it seems the Recordset opened with this table doesn't support the
AddNew method.
Could anyone tell me any possible reason of this?
Thanks a lot. |
|
|
p******e 发帖数: 31 | 4 我想用ASP添加数据库record时,总是报错。
请问是怎么回事? 谢谢!
我的数据库并没有设为只读啊。
程序如下:
<%
dim db
dim strCon
db="access"
strCon="DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=c:/Inetpub/wwwroot/name/name.mdb"
set db=Server.CreateObject("ADODB.Connection")
db.open strCon
%>
set res=Server.CreateObject("ADODB.Recordset")
res.Open "select * from
user",strCon,adOpenKeyset,adLockOptimistic
res.AddNew
res("pass")=pass
res("fname")=fname
res("lname")=lname
if city<>"" then
res("city")=city
....... |
|
p**i 发帖数: 688 | 5 Do you use addnew/update method with ADO recordset to add a record?
here ASP+access works fine for me, but it isn't serving lots of users. |
|