Access 数据库,用SQL分析器:delete from OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\mq.mdb";User ID=Admin;Password=')
...tmpRecords
where mqdate between '2015-07-01' and '2015-07-31'
错误:
OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 未能从表 'tmpRecords' 中删除。出现可恢复的、特定于提供程序的错误,如 RPC 失败。 Severity 16
如果把条件改为 mqdate =‘2015-07-01’,改为=号就没有错误??
...全文
1096打赏收藏
SQL 删除 ACCESS 数据错误
Access 数据库,用SQL分析器:delete from OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="d:\mq.mdb";User ID=Admin;Password=') ...tmpRecords where mqdate between '2015-07-01' and '2015-07-31' 错误: OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 未能从表 'tmpRecords' 中
delete from OpenDataSource('Microsoft.ACE.OLEDB.15.0',
'Data Source="d:\t.accdb";User ID=Admin;Password=')
...tt
where mqdate between '2015-07-01' and '2015-07-31'