how to remote update a licence key via CD or email

[dxp]

Hi, I am just about to install a database on another computer 300 miles away. The db has an expiry table which prevents access when a certain date is reached. Is it possible to update that table via an update on CD or email sent to that person with a new date so they can continue using the db. (In other words a form of licence key) at the click of a command button.

 

[melanie]

dxp, what about emailing them the a tiny db with one table and the new date. The little db contains an "update query" button, clicking the button will update the new date into the expiry table on their database. Can that be done?

 

[dxp]

hi Melanie, I tried that but I dont know how to get the update to automatically find the table in the remote db on the click of the update button on the form in the db sent in the email. It all needs to be automatic for the remote user as they have no experience with MS Access.

 

[gemma-the-husky]

if you have a date and a function that produces a check code for that date, then you can send the user the date and the code. As long as they cant guess the code from the date (ie some sort of complex function) you can probably get what you want

 

[melanie]

dxp - http://support.microsoft.com/kb/209871

this is instruction on password protecting a form. Have a form with this code pop up at the end of the trial period.

 

[dxp]

thanks for the suggestions, but I have hit a bad problem which needs to be sorted out before I can procede with this utility, see my other thread that happened last night (oh my god).http://www.access-programmers.co.uk/forums/showthread.php?t=126364

 

[melanie]

Oh dxp, how heartbreaking when you've worked so long and hard only to encounter a horrible situation. I wish you all the best in getting the problem sorted out. Please let us know how you fare!!!