openrowset problem to query Access DB

[Rainbow River]

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!

[rmiao]

Is the file opened by other ones when you run the query?

[Rainbow River]

Nope.
The Access db is in my local drive and I tried to use my local SQL account to connect it.
Any idea to use linked server ? How to go through the security configuration by adding the link server?
Thanks!

[MAK]

1. When using .mdw file you have to update the system registry
http://support.microsoft.com/?kbid=246255

2. When querying you could use opendatasource to specify the system database

select * from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\MyDB.mdb";Jet OLEDB:System Database="C:\MyMDW.mdw";User ID=MyUser;Password=;')...a1