By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,462 Members | 1,126 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,462 IT Pros & Developers. It's quick & easy.

Need code to deactivate database after certain period of time

P: 1
Is there any code which can deactivate / corrupt (delete main table) whole database after certain period (like after 1 month / or 6 months).

Please advise.
Mar 25 '10 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 3,532
Help me out says absolutely nothing about your problem here! Iíve re-titled your thread so that it actually reflects the question at hand. Having a title that does this clearly is important for two reasons.

First, it allows members, at a glance, to understand the nature of the question being asked. Thus, people who have never dealt with this or similar problems are saved the time and trouble of opening your thread. They would have nothing to contribute!

Secondly, and just as important, responsible people with questions first search for threads that address similar issues. Having a clear title facilitates these searches and saves everyone time and trouble.

Welcome to Bytes!

Linq ;0)>

Mar 25 '10 #2

Expert Mod 2.5K+
P: 2,545
Hi Unicon. What you ask is not common practice in Access database work. The last thing any of us want to do is to corrupt tables - so you simply will not find this as a 'solution' to what you ask.

It is possible to write a 'start date' entry to, say, the Windows Registry using custom VBA to do so (unlike writing to a table in the application, which the user can easily change). You could then use custom code to compare the start date to the current date to see if the trial period was over, but this would be up to you to research and implement.

A good book which covers manipulating the registry in VBA (amongst many other useful topics) is the VBA Developer's Handbook by Getz and Gilbert.

Mar 25 '10 #3

Expert 2.5K+
P: 3,532
Also note that while you have the right to prevent possible customers from continuing to use your app unless they pay the appropriate fee, you do not have the right to destroy their data! The app is your intellectual property and the actual data is theirs!

If they've spent many man hours taking your app for a "test drive," and like it, they'll pay the fee. Just make sure to explain clearly the length of the trial period. Getting a signed agreement, stating that they understand the terms, would be a good idea, as well.

Linq ;0)>
Mar 26 '10 #4

Expert Mod 15k+
P: 31,768
Locking this thread to ensure no helpful soul can suggest anything more directly related to the original question.
Mar 26 '10 #5

This discussion thread is closed

Replies have been disabled for this discussion.