Password property of User object

[Dave]

Is there any way to use the password property of the
dao.user class?
I want to have certain actions in my database require the
user to re-enter their password. I could just create a
table of passwords, but I would rather use the passwords
stored in the .mdw file if possible.
Any reference to the password property I have tried
produces as invalid use of property error. ie:
Dim colUsers As DAO.Users
Dim oUser As DAO.User
Dim wrkspc As DAO.Workspace
Set wrkspc = Application.DefaultWorkspaceClone
Set colUsers = wrkspc.Users
For Each oUser In colUsers
Debug.Print oUser.Name, oUser.Password = "1234"
Next oUser

 

[Eric Butts [MSFT]]

Hi Dave,

The Password property is Write-Only. Would need to create another means of
accomplishing your goal.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights



--------------------
| Content-Class: urn:content-classes:message
| From: "Dave" <[email protected]>
| Sender: "Dave" <[email protected]>
| Subject: Password property of User object
| Date: Sat, 5 Jun 2004 15:41:57 -0700
| Lines: 16
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRLTk60WnBM6wF2SaKcWwxYKn6PJQ==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:11184
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.security
|
| Is there any way to use the password property of the
| dao.user class?
| I want to have certain actions in my database require the
| user to re-enter their password. I could just create a
| table of passwords, but I would rather use the passwords
| stored in the .mdw file if possible.
| Any reference to the password property I have tried
| produces as invalid use of property error. ie:
| Dim colUsers As DAO.Users
| Dim oUser As DAO.User
| Dim wrkspc As DAO.Workspace
| Set wrkspc = Application.DefaultWorkspaceClone
| Set colUsers = wrkspc.Users
| For Each oUser In colUsers
| Debug.Print oUser.Name, oUser.Password = "1234"
| Next oUser
|