请帮助我解决数据库编程的一个问题
程序如下:
dim db as new adodb.connection
dim rsado as new adodb.recordset
db.open "provider=msdasql;dsn=test;uid=;pwd=;"
rsado.open "select * from p9908",db,dbopenkeyset,dblockoptimistic
set datagrid1.datasource=rsado
rsado.delete
且datagrid1的allowdelete属性设置为true,当执行删除时,出现错误,错误信息如下:
run-time error'-2147467259(80004005)':
[Micosoft][ODBC dBase Driver]Cannot update.Database or object is read-only.