Annual Renewal of User Subscriptions

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

Guest

I distributed database to users in field. Program runs for 365 days (I
created table that counts down from Jan 1 to Dec 31). After Dec 31, unless
the table is reset, users can no longer access the database. Now is time to
renew the subscription.

What is the best way to have users reset the table? (One approach is to send
them a batch file that resets the table. However, to prevent unauthorized
resets, the batch file would only be allowed to execute once.)

Any other ideas on how to solve this? Or, is there a more elegant approach
that does not use a table to countdown from Jan 1 to Dec 31?
 
Holy heck! Counting down using a table is really not the way to go.
Maybe it works, but it shows a lack of understand about how to do
things properly :-)

A better approach would be to use a database property. On each open of
the database, see if the property does or doesn't exit. If it doesn't,
create it with tody's date. If it /does/, subtract it from today's
date, to get the # of days since the system was run for the first time.
If that # is > 365, for example, then you can do your "database has
expired" thing.

Check Access help for the CreateProperty method.

HTH,
TC
 
Back
Top