我在其它窗体用recordset对象都没问题,唯独在一个窗体报错说"在一个已关闭的或无效连接的对象参照上操作不被允许",就算我在这个窗体下只有最简单的
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=企业贷还款.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
hksql = "select * from 企业还款表"
rs_huankuan.CursorLocation = adUseClient
rs_huankuan.Open hksql, Conn, adOpenKeyset, adLockPessimistic
也不行,数据库连接和对象声明都没问题,真是太莫名其妙了,万望高手指点!
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=企业贷还款.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
hksql = "select * from 企业还款表"
rs_huankuan.CursorLocation = adUseClient
rs_huankuan.Open hksql, Conn, adOpenKeyset, adLockPessimistic
也不行,数据库连接和对象声明都没问题,真是太莫名其妙了,万望高手指点!
set rs_huankuan=new adodb.recordset
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=企业贷还款.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
conn.open conn.connectionstring '该行是我添加的
hksql = "select * from 企业还款表"
rs_huankuan.CursorLocation = adUseClient
rs_huankuan.Open hksql, Conn, adOpenKeyset, adLockPessimistic我在你的代码中添加了我的一行代码
你再试试看行不