TimeBomb Feature...

[DanG]

I am going to send a database to a Vendor with only names & addresse.
What I'd like to do is have it delete itself in 30 (or so) days. I am able to delete the tables, queries, forms and reports if I call them out but what I'd really like to do is just reference the database name and delete the whole thing at startup after 30 days.

Here is the hard way to do it code I have..

Function Tbomb()
If (Now() >= #6/23/2005 3:01:16 PM#) Then
DoCmd.DeleteObject acTable, "time"
End If

End Function

Any ideas?

 

[bradcccs]

Without extensive coding, I think you will have trouble deleting the db itself, as the file will be open to execute the code, thus it won't be able to delete itself.

Further to this concept:
I assume you wish to promote (and hopefully sell) your project to this client. I would consider it a better option to delete your data as you have proposed, and alter the startup form to simply display a form with your project details and contact info. This way the client will be reminded how to contact you to purchase your helpful product. Just a thought.

 

[ThreeCrow]

Would it be better to use some code to lock down the database, with a back door to unlock. Some clients are a little slow, when it comes' to give up money for what really do need. By locking it down you retain any changes that they or you have made.

And most important thier data is intact, for when and if they do pay.

Just another view.

 

[DanG]

I wish I could write something important enough for somebody to pay for.
In truth I am doing a very large mailing (I'm in the Marketing Department).
My vendor is a printer and I don't think they need to keep the info after they are done.
I know I could get by with just deleting the client table (I know how to do that) but I am just starting to learn VBA and well it just seemed kinda cool to be able to blow the whole database up as opposed to just take out a little bit of it.
Actually, being so new, I am just searching for ways to apply what I know and building on it.

Thank you both for you comments!

 

[pacav69]

Locking code with serial generator

I wish I could write something important enough for somebody to pay for.
In truth I am doing a very large mailing (I'm in the Marketing Department).
My vendor is a printer and I don't think they need to keep the info after they are done.
I know I could get by with just deleting the client table (I know how to do that) but I am just starting to learn VBA and well it just seemed kinda cool to be able to blow the whole database up as opposed to just take out a little bit of it.
Actually, being so new, I am just searching for ways to apply what I know and building on it.

Thank you both for you comments!

Here is something that i think you can use

http://www.downloadjunction.com/product/software/29255/

It is a serial generator that i think would solve your problem

Cheers
Paul