Password Protect Form

H

Heather

Hello,

I followed the following instruction from Microsoft website on How to Create
a Password Protected Form or Report. http://support.microsoft.com/kb/209871

It works the way I wanted with one exception. When a user does launch the
form enters the password on frmPassword correct and enters the main form>
user closes the main form> re-launch > Get the frmPassword again > user just
closes frmPassword > It Opens the Main form anyway. (note before the user
ever enters a password in frmPassword > user closes >frmPassword will just
close)

Seems to be keeping it in memory once the user puts in the correct password.
Is their a way when the Main form closes to clear memory because maybe the
form is not really closed down?

Thanks,
Heather
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

password protected to sub form 0
Password protect new workbooks from template 0
[Access 2007] Runtime Error 3219 1
Crating User Form to Add Names 1
global/public variable 2
Password Protect Form 4
How to change a password in a form? 3
Access 2003 --> Access 2007 code no longer working 6

Top