对象变量或with块变量未设置解决思路
对象变量或with块变量未设置
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=pubs (SQL Server)"
Adodc1.Recordset.Open "select * from 供货商", Cnn, adOpenKeyset, adLockOptimistic (对象变量或with块变量未设置)
------解决方案--------------------
Adodc1.Recordset.Open "select * from 供货商"就行了，后面的Cnn没必要，代码中前面也没说明
------解决方案--------------------
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=pubs (SQL Server)"
Adodc1.Recordset.Open "select * from 供货商", Cnn, adOpenKeyset, adLockOptimistic (对象变量或with块变量未设置)
------解决方案--------------------
Adodc1.Recordset.Open "select * from 供货商"就行了，后面的Cnn没必要，代码中前面也没说明
------解决方案--------------------
- VB code
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pubs;Data Source=pubs (SQL Server)" Adodc1.RecordSource = "select * from [供货商]" Adodc1.Refresh