Lock Out Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am interested in requiring a 'lock out key' in order for a user to access a
database on a monthly basis. I have no idea how to do this but I suspect it
can be done. Just to clarify; I want to require that the user enter a code
or key supplied by me in order to continue using the database. Any help
would be greatly appreciated.
 
I am interested in requiring a 'lock out key' in order for a user to
access a database on a monthly basis. I have no idea how to do this
but I suspect it can be done.
Click to expand...

Depends on the knowledge of your users. If they are really naive, then a
simple bit of VBA can be called from an Autoexec macro:

If glb_dtLicenceDate + 28 < Date() Then Application.Quit

but if they know how to press <shift> on starting the application then
it'll be bypassed. You can continue to make life difficult, though, by
littering the same code throughout your forms and reports.

If they are more able, you might have to resort to Access security and just
remove User objects when their licence runs out -- it's easiest to do this
at startup, since there is no Application.Closedown event chiz chiz.

Finally, it is probably possible to build a DLL that times itself out and
kills the application.

Hope that helps -- I've never attempted any of these methods though!!

Tim F
 
Thanks for the input. I think the one line of code in the Autoexec Macro
will be sufficient to confound most users. Can the single line be altered to
accept a monthly 'code' that must be typed in like a password instead of
linking it to the date alone.
 
Back
Top