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.
'c:\program files\new.sdb';'sysadmin';'admin', tcustomr)
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.