Hi,
I am able to excute a select query suceefully in the same server.I am getting below error when i excute the same query in another sql2005 management studio.
[OLE/DB provider returned message: The Microsoft Jet database engine cannot open the file '\\142.40.42.105\cas_2000\report\JKTBILL.mdb'. It is already opened exclusively by another user, or you need permission to view its data.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
please help me to resolve this.
thanks.