I have a front end that does a bunch of work. One thing it does is open a particular MS Access database that is password protected. The front end currently uses AppActivate and SendKeys to key in the password for the user.
I know, this is a bad way to do it for so many reasons. That is why I need your help.
How can I use PostMessage (or any other API method) to communicate directly with the password window so another application can't intercept the key commands and see the password?
Windows XP, VB6, MS Access 2000