Close on date

[JSHEL]

Is there a way to have access look at the current date on open and if it's past a specific date close the database?
I'm look to put this in Autoexec Macro. or if there is a better way.


Thank you for your time,
Jshel

[ajetrumpet]

store the threashold date in a table and look it up via comparison using DATE() with the macro. issue a:

docmd.quit

command if the date is past.

why are you doing it? trial software?

[pbaldy]

You can do it with a macro condition of:

Date()>#12/01/2010#

Hopefully you realize that any knowledgeable user will be able to get past it (and probably anything else you might try).

[JSHEL]

Thank you for the quick responses. I do realize it's easy to get around just about anything in access <shift>. The person i'm sending this DB to is strictly an end user. LOL (trying to be nice) I just don't want the DB to be used with out payment first. Kind of a sample DB.

[ajetrumpet]

thy this to disable that key: http://support.microsoft.com/kb/826765

[JSHEL]

Great information Thank you very much.