vBA .exe file to update record?

[SawyerTyler]

Hi.

I have a table with product expiry date, when the database opens it checks the expiry date, if the license has expired it will notify the user and close down.


When the user purchases a new license, I want the user to run a VBA script that I send by email that updates the record in the table with a new date.

The database is being run as a desktop application and I have no access to it.

Is this possible?

 

[Gasman]

Look at similar threads at the bottom of this thread.
Exactly the same title was asked a few weeks back. Strangely enough with the same typing error and spacing?

In actual fact it looks like you have just copied the post?

 

[arnelgp]

use a "service' database (.accde) that will update the Expired db.
the process is very simple.

 

[theDBguy]

Hi. Welcome to AWF!

I would also suggest prompting the user to enter the new license info from your email and let the program update itself.