How to Access Ms-Access WorkGroup tables to change database login password
- Thread starter kishoremf
- Start date
Dennisk
AWF VIP
- Local time
- Today, 22:03
- Joined
- Jul 22, 2004
- Messages
- 1,649
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.
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.
- Local time
- Today, 16:03
- Joined
- Feb 28, 2001
- Messages
- 30,314
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.
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.
