PC Review


Reply
Thread Tools Rate Thread

Database 30 Day Password

 
 
Rod
Guest
Posts: n/a
 
      16th Jan 2009
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!
 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      16th Jan 2009
On Fri, 16 Jan 2009 04:52:01 -0800, Rod
<(E-Mail Removed)> 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!

 
Reply With Quote
 
Rod
Guest
Posts: n/a
 
      16th Jan 2009
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
> <(E-Mail Removed)> 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!

>

 
Reply With Quote
 
Tom van Stiphout
Guest
Posts: n/a
 
      17th Jan 2009
On Fri, 16 Jan 2009 06:47:02 -0800, Rod
<(E-Mail Removed)> 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
>> <(E-Mail Removed)> 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!

>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password on database - allow users to open front-end w/o password =?Utf-8?B?VHJhY2k=?= Microsoft Access Security 1 8th May 2006 09:04 PM
I saved password into the database with "binary" data type from GetByte method. How can I to compare the password that between database and transfered from the page? Benny Ng Microsoft Dot NET Framework 3 25th Jan 2006 06:49 AM
I saved password into the database with "binary" data type from GetByte method. How can I to compare the password that between database and transfered from the page? Benny Ng Microsoft ASP .NET 3 25th Jan 2006 06:49 AM
I saved password into the database with "binary" data type from GetByte method. How can I to compare the password that between database and transfered from the page? Benny Ng Microsoft Dot NET 3 25th Jan 2006 06:49 AM
using Properties("Jet OLEDB:Database Password").value = xxxxxxx opens database with no password db Microsoft Access Security 0 16th Sep 2003 06:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:31 AM.