向access添加数据时报错为数据库引起擎打不开文件'\\192.168.1.2\E$\Tdata.mdb'.它已经被别的用户以独占方式,或没有查看数据的权限.
配置为: insert into openrowset('Microsoft.Jet.OLEDB.4.0',
'\\192.168.1.2\e$\经管院数据转移工具\TData.mdb';'admin';'',CURRENCY_Center)
(ControlCord,BookMan,BiblioTheca,BiblioThecaIssue,BiblioThecaNumber,Title,TitleSeries,
ISBN,Author,Publisher,Publish,PublishDate,PublishVersion,LIBCord,Language,UnitPrice,UniteCord,
MarcData,LIBCordNum,CatalogueDate,CatalogueMan,WealthCord,LIBNum)
select ControlCord,BookMan,BiblioTheca,BiblioThecaIssue,BiblioThecaNumber,Title,TitleSeries,
ISBN,Author,Publisher,Publish,PublishDate,PublishVersion,LIBCord,Language,UnitPrice,UniteCord,
MarcData,LIBCordNum,CatalogueDate,CatalogueMan,WealthCord,LIBNum from DLAS..NewCURRENCY_Center
配置为: insert into openrowset('Microsoft.Jet.OLEDB.4.0',
'\\192.168.1.2\e$\经管院数据转移工具\TData.mdb';'admin';'',CURRENCY_Center)
(ControlCord,BookMan,BiblioTheca,BiblioThecaIssue,BiblioThecaNumber,Title,TitleSeries,
ISBN,Author,Publisher,Publish,PublishDate,PublishVersion,LIBCord,Language,UnitPrice,UniteCord,
MarcData,LIBCordNum,CatalogueDate,CatalogueMan,WealthCord,LIBNum)
select ControlCord,BookMan,BiblioTheca,BiblioThecaIssue,BiblioThecaNumber,Title,TitleSeries,
ISBN,Author,Publisher,Publish,PublishDate,PublishVersion,LIBCord,Language,UnitPrice,UniteCord,
MarcData,LIBCordNum,CatalogueDate,CatalogueMan,WealthCord,LIBNum from DLAS..NewCURRENCY_Center
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货