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