Password protect a control button

  • Thread starter Thread starter Hugh self taught
  • Start date Start date
H

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)
 
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
 
Back
Top