Expiration Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am sending an access file to someone to review for 30days. After that
30days I want the database to be non-functional. Is there a way to remove
the functionality after 30days, auto-delete, or lock it after a specific
date? In the alternative, is there a way to require a keycode or password to
be entered to keep working after 30days?
 
That sounds like what I am looking for, but is way beyond my limited skills.
Is there anything else that has more step by step assistance?
 
I'm not aware of any. Limiting the number of records in some key table may
suffice (set a validation rule on an Autonumber). However, it is difficult
to implement something in Access because users need access to the file in
order to use it. Anything you try, they can likely undo.
 
Limiting the number of records in some key table may
suffice (set avalidationrule on an Autonumber).
Click to expand...

Shurely some mistake?

http://groups.google.com/group/microsoft.public.access.setupconfig/msg/53e4b05d8ca31bd0
"you do realize that autonumbers will have gaps, and can be
negative." Joan Wild Access MVP

http://groups.google.com/group/microsoft.public.access.gettingstarted/msg/d791dbd427159c0c
"you shouldn't care what the value of an autonumber is, as there
will always be gaps." Joan Wild Access MVP

http://groups.google.com/group/microsoft.public.access.security/msg/f3aaba08b0d8d6f6
"An autonumber is not meant to be used as anything with meaning to the
user.
If a user starts...but doesn't complete the record (hits
escape for eg.), that autonumber will not be re-used." Joan

Need I say more?

Jamie.

--
 
I found a solution for the same thing on another group.

Function DMVsn()

Dim TodayDate, CutoffDate As Date
CutoffDate = #1/1/2007# ' Program will not run after this date
TodayDate = Date
If CutoffDate < TodayDate Then
MsgBox ("The system has been in-activated") ' or any other warning
Message
DoCmd.Quit
ElseIf CutoffDate > TodayDate Then
Exit Function
 
Back
Top