当前位置: 代码迷 >> Sql Server >> sqlserveropenrowset导入Access数据库,发生Cannot start your application. The workgroup information file is missing or opened excl,该怎么处理
  详细解决方案

sqlserveropenrowset导入Access数据库,发生Cannot start your application. The workgroup information file is missing or opened excl,该怎么处理

热度:421   发布时间:2016-04-27 19:59:02.0
sqlserveropenrowset导入Access数据库,发生Cannot start your application. The workgroup information file is missing or opened excl
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) ".




------解决方案--------------------
先把工作组权限去掉,然后导入数据。
  相关解决方案