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)".
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)".
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货