在ADO中,Access数据库的jet引擎是不是不支持修改用户密码
使用ADOX(ADO externsion)读出和修改数据库的用户密码,提示如下:
Object or provider is not capable of performing requested operation
代码如下:
Dim user As adox.Users
Dim catalog As adox.catalog
Set catalog = New adox.catalog
catalog.ActiveConnection = "Provider=microsoft.jet.oledb.4.0;data source=e:\db1.mdb;user id=admin;Jet OLEDB:Database Password=cs.net"
For Each user In catalog.Users ''''此行出错
MsgBox user.name
Next
大侠指点呀