Password protect a control button

[Hugh self taught]

Hi Guys & Gals,

I have a delete query which will clear all the existing data in the
database, which believe it or not is sometimes the case in this specific
scenario. That of course is so dangerous to leave unprotected & I need a
simple way to password protect it. A simple idea was to make it the current
system date & that way it's also not a specific word etc to remember. Any
ideas on how to code that & get out of it before the query actually executes?
I'd really appreciate the help.

Cheers, (not to my data just yet)

 

[Tom van Stiphout]

On Wed, 1 Apr 2009 05:28:01 -0700, Hugh self taught

If CDate(InputBox("Secret password?")) = Date Then
DeleteAllData
End If

-Tom.
Microsoft Access MVP