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!

Giving Access program an expiraton time (like a demo version) 1

Status
Not open for further replies.

talontc

MIS
Sep 5, 2008
4
US
I'm creating an Access 2003 db for a small company and would like to send them a copy of what I have finished so far. I would like to add an expiration or "Trial Version" functionality to it so that it is only usable for a limited time period. Is there any way to do this in Access or VBA?
Thank you for any help.

Dan Tuma
Talon Tech.
 

The simplest way is to check the Date in your app:
Code:
If Date > "9/5/2008" Then
    MsgBox "Trial period is over."
    End
End If
This, of course, does not prevent your user to change the machine settings (date) to have your app for longer, but people are lazy and may not know how you did it.

Have fun.

---- Andy
 
How does this code disable/end the program?
Dan
 
I'd use this instead:
If Date > #2008-09-05# Then
MsgBox "Trial period is over."
Application.Quit
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Where in the code window would I enter this, on the main forms Load event?
 
You should hide it a little, I mean the load event is a little obvious, isn't it?

Save it as a worksheet function or stick it in a module, and chain a couple of do-nothing calls to functions together, put a call to a gettime() function in the load event, then call something else in it...

And don't name the actual function "deadbeats(dte as date)"

:)
 
Got it. Makes allot of sense
Thank you
Dan Tuma
Talon Tech
 

What I've done is hide the cutoff date in the Tag Property of the form, then use something like
Code:
Private Sub Form_Load()
 If Date > Me.Tag Then 
  MsgBox "You have encountered a problem! Please call ABC Developers to report this error!"
  Application.Quit
 End If
End Sub

Then when they call, you've got them! What you have to keep in mind, I think, is that if the people using your apps were that Access savvy, they'd be developing their own databases instead of using off the rack apps from someone else and looking to cheat you.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top