Need code to deactivate database after certain period of time

[Unicon]

Hi
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.

[missinglinq]

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)>

Moderator

[Stewart Ross]

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.

-Stewart

[missinglinq]

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)>

[NeoPa]

Locking this thread to ensure no helpful soul can suggest anything more directly related to the original question.