I know it sounds fishy......

[GizmoT]

...... but is there a way of automatically and deliberately corrupting a database, or preventing it from working.

Why????


I want to send a copy of a database to a potential client, but I am obviously concerned that once he has it, he won't need to buy it.

I have created a form that loads on start up to check that the time limit hasn't expired, and if it has, it asks for a renewal code, which they have to ring up for. But I am concerned that, with a little knowledge, someone could get round the system, and continue using it.

What would be sweet is if someone tries to use it without permission, it wipes it all out.

Any ideas???

 

[Vassago]

Have it delete all the tables after the elapsed time if they try to enter the database too many times after the expired time limit. That's something that might work for you. Don't know exactly how bad you want to "corrupt" the database.

 

[GizmoT]

Vassago


That sounds fine, but how do you delete a table?

 

[Pat Hartman]

You don't need to delete a table, although you could. You can just run a delete query to delete all the rows.

To delete a table, use the tabledef collection or look up DROP TABLE in help. If you are using A2k or newer, you will need to open help from the database window, switch to the contents tab, and find the entry for Microsoft Jet SQL. There is where you will find everything you need to know.

 

[Vassago]

DoCmd.DeleteObject acTable, "table name"

That should delete a table for you. You could also try looking in Access help for deleting the records from the tables using a delete query instead of deleting the tables themselves.

That should do you.

Vassago

 

[Vassago]

Okay, Pat beat me to it. I would follow her advice. She is "the one" in our Access Matrix.

 

[GizmoT]

Thanks SO much for the help guys.

Just what I was hoping for.



Keep up the good work