Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xplorr2
Starting Member
1 Post |
 Posted - 2006-12-18 : 17:04:56
|
| I'm trying to open a multi user access DB using 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:SELECT a.*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 filemy DAO code is as follows:USER = sysadminPW = adminSet 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 OLEDB:SystemDatabase='c:program files\new.sdw'how do I replicate the DAO solution towards openrowset. Could someone provide a sample? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Openrowset syntax for secured multi user Access DB