making expire ms access form..

[alex_raju]

hi,



i have done a stock management system in ms access 2003 it is working well,
now i am going to sell it to some shops at the same time also i want give one month or some days as a trail- now, if they don't buy it or if they make copy my database it should expired after some fixed days ( cannot be use ) untill i remove the expire option

please tell me is there any way to do this...

thankyou

[TheShabz]

I'm not sure of a way to "lock" it as you are mentioning. However,

What I would do is create a hidden blank form on db open that would:
If Date() >= someDateYouDecided Then
'code to delete all your queries

Of course, this is pretty harsh but once the queries are gone, the db is useless. This would also allow your client to export data from the tables. It's almost like strapping a time bomb to your database

[alex_raju]

first of all thank you for u r quick answer, i mean it won't delete database, i want like can auto change form password or when they click after specific date form cannot be open message, or when they open it can auto close like

If Date() >= "#14/06/2011#" Then
MsgBox ("This databse has expired.")
DoCmd.Quit
End If