Is there a function within Access that will allow me to set a time limit as to how long a base can be used for. I plan to burn a base to disc and distribute it to potential customers. This is only for demonstration purposes and hence the access to the base should not be permitted after a specific length of time. Any suggestions greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Database Expiry
- Thread starter SRogers1
- Start date
Hello,
use a hidden table with 3 or 4 fields:
date_of_the_last_possible_call - datetime
number_of_starts - int
starts_counter - int
start_permitted - boolean
Check the start_permitted field on start.
Docmd.close if start is not permitted.
Complain on every start if the date run off -> set the start_permitted to false
OR/AND:
Set the starts_counter to starts_counter+1 and complain with the number_of_starts -> set the start_permitted to false if the comparison result equality
Thats it!
If you need the code inquire simply again.
regards
daniel
use a hidden table with 3 or 4 fields:
date_of_the_last_possible_call - datetime
number_of_starts - int
starts_counter - int
start_permitted - boolean
Check the start_permitted field on start.
Docmd.close if start is not permitted.
Complain on every start if the date run off -> set the start_permitted to false
OR/AND:
Set the starts_counter to starts_counter+1 and complain with the number_of_starts -> set the start_permitted to false if the comparison result equality
Thats it!
If you need the code inquire simply again.
regards
daniel
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question