有请高手！！！！！！！

Question

adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\fyzInfo.mdb;Persist Security Info=False"
adocon.CursorLocation = adUseClient
reset1.Open "
select *  from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=(local);User ID=sa;Password='
         ).pubs.dbo.authors", adocon, adOpenDynamic, adLockOptimistic

Answer 1

你的openrowset的用法有些问题,改为:adocon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\fyzInfo.mdb;Persist Security Info=False"
adocon.CursorLocation = adUseClient
reset1.Open "SELECT * FROM OPENROWSET('SQLOLEDB','(local)';'sa';'',pubs.dbo.authors)", adocon, adOpenDynamic, adLockOptimistic