Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sergio CV
Starting Member
1 Post |
 Posted - 2010-11-03 : 11:53:36
|
| HelloIm trying to make a query to a Access 2000 Database using a OLE DB Provider for Jet (Linked Database) and SQL Authentication. The datasource is a .mdb file available in a shared directory in another Windows Server.I have no problems with the linked server while using Windows Authentication with the proper permisions in the shared directory. But when i try with SQLAuthentication i got the following error:OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMCAccess2" returned message "The Microsoft Jet database engine cannot open the file '\\wintermute_13\media\mdb\acd4.mdb'. It is already opened exclusively by another user, or you need permission to view its data.".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMCAccess2".Testing with multiple configurations for the security results in diferent errors like this one:OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMCAccess2" 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 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMCAccess2" reported an error. Authentication failed.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMCAccess2".Any advice or work around for this situation? Is posible to use linked servers in a shared directory while using SQL Authentication?Thanks in advance. |
|
|
|
|
|
Linked Server. Auth Problem with Access 2000