Hi,
If it's a database password and NOT User Level security then.....
(you also mentioned that you open the database via a hyperlink in Word
document)
you've ran into issue where opening database via Word or a macro in Word
document causes a password to be assigned to database file, see: 321905
ACC2000: Database Password Prompt Appears After You Open a Database
http://support.microsoft.com/?id=321905
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support