sqlserver2005 openrowset导入Access数据库,发生Cannot start your application. The workgroup information file is missing or opened exclusively by another user问题,
Access数据库设了密码,如果把密码去掉,是没有问题的。
select *
from
openrowset( 'Microsoft.Jet.OLEDB.4.0 ', 'd:\db1.mdb '; 'admin '; 'pan ',H_Business)
路径是对的,我把密码去掉之后,是可以打开的。
详细错误信息
OLE DB provider "Microsoft.Jet.OLEDB.4.0 " for linked server "(null) " returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user. ".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0 " for linked server "(null) " reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0 " for linked server "(null) ".
------解决方案--------------------
先把工作组权限去掉,然后导入数据。