Passwords (AccessXP)

[Marie-Therese]

Is it possible to synchronise the Access password with the Windows password? I would like to secure my Access database, but don't want to have to change the passwords continually.

Thanks!

[WendellB]

In general, no - the Access password is stored in the security file (system.mdw or whatever you choose to name it), while the windows password may be stored on the local workstation, or on the domain controller depending on the network configuration you use. You can manipulate the security system in code - there are lots of details in the Access Developers Handbook, but the challenge is getting at the Windows password and doing simultaneous administration. Now SQL Server is a different story.