Re: time limited passwords
- From: "TC" <aatcbbtccctc@xxxxxxxxx>
- Date: 2 Apr 2005 21:34:36 -0800
Rugby, the method I suggested is very crude & easy to hack. But if you
wanted to try it, here's what you'd do.
1. Write a standard module containing the following function:
public function Startup()
msgbox "STARTED!"
end function
2. Use Tools : Startup to define that function as the startup function
of the database. (I've forgotten exactly what the field is caled on the
screen.)
3. Close then re-open the database. Make sure the message appears. If
it doesn't you've done something wrong.
4. Now replace the MsgBox statement with the following code:
if XXXXX(dbengine.systemdb) - date() > 30 then
msgbox "sorry, you need a new security file"
application.quit
endf
5. Replace XXXXX (above) with the name of the function that returns the
creation date/time of the specified file. I can't remember what that
is, and I don't have Access here to check.
Now the message should appear when you start the database & the
workgroup information file is more than 30 days old.
As I said, that method is crude, and easy to hack - but maybe it would
do for your purpose.
If you still can't work it out from here, I recommend that you get a
book on Access programming, so you can follow some structured examples.
My concern is, that at present, you can not really make an informed
decision between the "el cheapo" method suggested above, and the other
ways of doing this.
Good luck!
TC
.
- Follow-Ups:
- Re: time limited passwords
- From: rugby............where's Johnny?
- Re: time limited passwords
- References:
- Re: time limited passwords
- From: rugby............where's Johnny?
- Re: time limited passwords
- Prev by Date: Re: New to security have questions before plunging
- Next by Date: Re: call change user password
- Previous by thread: Re: time limited passwords
- Next by thread: Re: time limited passwords
- Index(es):
Relevant Pages
|
