Expiration Date

[rbb101]

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?

 

[Joan Wild]

Read Tony's thoughts on this at http://www.granite.ab.ca/access/demo.htm

 

[rbb101]

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?

 

[Joan Wild]

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.

 

[vvariety via AccessMonster.com]

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