Hi, there
I wrote a OpenRowset query in SQL Server 2000 to access my 2003 Access DB:
select *
from OpenRowset ('microsoft.jet.oledb.4.0', 'G:\myFolder\myDB.mdb';'myname';'myPWD','myTable')

I got error:
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'microsoft.jet.oledb.4.0' reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
OLE DB error trace [OLE/DB Provider 'microsoft.jet.oledb.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]."

The Access DB is password protected and My login was added to the work group. When I open Access DB directly, it would asked me work group login name & password. Then it asked DB password.

I know something tricky here about work group and password. How to solve this problem by using OpenRowset query?

Thanks!