Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Serious BUG with ADOX & user password/groups


Message #1 by andrew.c.watts@b... on Fri, 23 Jun 2000 4:57:51
Javier,

I tried emailing a reply to your address - but 2X returned as 
undeliverable.

I am using ADO 2.5 at home. I can get tables up just fine.

The problem is the general Data Base level password  - NOT user lists.
with individual passwords.

EX:
ADO allows opening an ACCESS DB with simple password protection

ADOX allows manipulation of user & group level passwords BUT this is
NOT the same as a simple DB password.  

How can I get this same functionality for ACCESS with ADO ???
DAO:
Set thisDb = OpenDatabase(thisdbname, True, False, ";pwd=foo")
thisDb.NewPassword "foo", ""
thisDb.Close

ADO:
This ADO opens the ACCESS DB, but does not provide a method to change
Password !

ADOJetProvider = "Microsoft.Jet.OLEDB.4.0"
Set Jetconn = New ADODB.Connection
With Jetconn
.Provider = ADOJetProvider
.ConnectionString = strMDBpath
.CursorLocation = adUseClient
.Properties("Jet OLEDB:Database Password") = Mypwd
.Open strMDBpath
End With


I don't have USER level security -  just setting a password for opening a 
database.

So does ADOX apply to that password.    ???

Thanks ! Andrew



  Return to Index