I'm trying to open a multi user access DB with user and PW. The mdb has been locked down to disable the admin account I know for a fact that I should be able to open the mdb under the user=sysadmin and the PW=admin. I can open the DB using DAO but not using openrowset.

My code:
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\program files\new.sdb';'sysadmin';'admin', tcustomr)
AS a
I get the error:
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.]

my only idea is that the openrowset needs an argument that refers to the mdw file

my DAO code is as follows:
USER = sysadmin
PW = admin
Set saShrdb = wks.OpenDatabase("myfile", , False, "ODBC;DSN=test: newl.SDB;DBQ=" c:\program files\new.sdb ";SystemDB="c:\program files\new.sdw";UID=" & USER & ";PWD=" & PW)

is there a work group argument for openrowset? eg: 'Jet OLEDBystemDatabase='crogram files\new.sdw'

how do I replicate the DAO solution towards openrowset sql.

Could someone provide a sample?

create a database in access with a workgroup file create a user and PW. now try opening that DB. if it works post you code.

I've tried everything and it's driving me nuts.