Re: Database 30 Day Password
- From: Tom van Stiphout <tom7744.no.spam@xxxxxxx>
- Date: Fri, 16 Jan 2009 21:15:53 -0700
On Fri, 16 Jan 2009 06:47:02 -0800, Rod
<Rod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
The thing with these algorithms is that they should remain somewhat
secret, so you won't find much help. But it's really not that
difficult; the keywords would be Mid$, InStr, Chr, Asc.
What I meant is that you would not want to make the data inaccessible
to the user, just the application. Hijacking one's data is frowned
upon, whereas disabling one's program for non-payment is capitalism.
-Tom.
Microsoft Access MVP
Sounds like that could do it - simple. Any ideas where I can find an example.
or get some help?
What do you mean by lock the DATA?
"Tom van Stiphout" wrote:
On Fri, 16 Jan 2009 04:52:01 -0800, Rod
<Rod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
There is nothing built-in that can do this, but you can write a VBA
function. It would generate a password based on an algorithm that is
difficult to predict for your user. For example it can use a random
starter password of "dlso2cug65shlkug" and the next one is 1, 2, ... N
ascii values higher than the previous letter: "envs..." etc. Of course
you need to wrap-around after "z".
Be sure not to lock the DATA for the user; that is typically frowned
upon and may be illegal in many jurisdictions.
-Tom.
Microsoft Access MVP
I would like to distribute a database for standalone use but have it only
work for 30 days at a time. To enable it to work for 30 days at a time I
would like to require the user to put in a password which I will provide.
This password needs to be generated on my end monthly and the users end
should be looking for this password every 30days; without this password the
database should not open. The password is to change every 30 days. How can
I do this?
Thanks MUCH!
- References:
- Database 30 Day Password
- From: Rod
- Re: Database 30 Day Password
- From: Tom van Stiphout
- Re: Database 30 Day Password
- From: Rod
- Database 30 Day Password
- Prev by Date: Re: Linking to a password protected BE from FE
- Next by Date: Re: How to Identify a Digitially Signed Database ?
- Previous by thread: Re: Database 30 Day Password
- Next by thread: O-2003 mdb with O-2003 and O-2007 users
- Index(es):
Relevant Pages
|