kishoremf
04-13-2007, 03:18 AM
Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
Dennisk
04-13-2007, 03:48 AM
Access has two types of password, one a simple database password and the other is a password allocated to a user. The former is set from Tools/Security Set/Unset Password and is stored in the database itself.
The latter is accessed via Tools\Security\User and group accounts and is stored in the workgroup file (which cannot be accessed directly). Although even the Owner of the database cannot access users passwords. These can only be cleared then re-entered.
kishoremf
04-13-2007, 04:49 AM
Hi!
Thanks for ur quick reply. But I need to do this using Code/Script.
If u have any idea abt this please send me the code.
Regards,
Kishore
Dennisk
04-13-2007, 04:52 AM
what type of password is it? a database password or a user password in a workgroup?
The_Doc_Man
04-13-2007, 09:24 AM
If it is a workgroup password, you can only clear it. And AC95? Sheesh, that's a LONG time ago. Not less than 8 major versions, maybe 9. I don't recall what is available and have no AC95 to check.
Go into Access Help and try to find information about Users (which is a collection). If you see that topic, see if there is a link to its properties and methods. If there IS a code way to accomplish what you want, the documentation will be there. If it ain't there, you can't do it.