向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