make the databse ask for password after a while

[oliver916]

Hi...,


can any one help me for code to make my database ask for password after while like one week or one month & it's most be some how that people can't do trick on it by changing computer date

& I Will be very thankful



sooory for my English

 

[Atomic Shrimp]

What kind of user account structure, if any, do you currently have in place?

 

[oliver916]

What kind of user account structure, if any, do you currently have in place?

there is no account
any one can use

but i didn't uderstant what u mean by "do you currently have in place"

 

[Atomic Shrimp]

OK, so the first thing you need to do is to set up your database so that it controls who can log in - there's an example in the samples database forum that might get you started on that - here:
http://www.access-programmers.co.uk/forums/showthread.php?t=170781

 

[oliver916]

ok i will do it
but can i know why ?

 

[oliver916]

done
what is the next step?

 

[Atomic Shrimp]

Ah, wait a moment, I just re-read your original post and I think I misunderstood your question - are you talking about making your whole application expire after a set time (i.e. to control software licensing)?

 

[oliver916]

yeep
that's it
that what i need

but no problem your example was good for me
i put it in my database


so now what should i do?

 

[Atomic Shrimp]

I'm not sure - because of the way Access works, it's quite difficult to shut a determined user completely out - but here's a link that might have some useful ideas in it:

http://www.access-programmers.co.uk/forums/showthread.php?t=95390

 

[oliver916]

sorry but I couldn't get any thing from the above link


any thing else plz?:

 

[smig]

you can set the first date the aplication was opened in the registery and check for it each time it is opened.
still there is nothing to prevent the user from changing the machine time or editing the registery himslef, other then breaking his hands

My guess is you want to create some demo option.
I guess it will be easier to do this based on number of trials, based on counter to be saved in the registery. most novice users won't look there

other then that you can limit the number of records for a demo.

 

[oliver916]

you can set the first date the aplication was opened in the registery and check for it each time it is opened.
still there is nothing to prevent the user from changing the machine time or editing the registery himslef, other then breaking his hands

My guess is you want to create some demo option.
I guess it will be easier to do this based on number of trials, based on counter to be saved in the registery. most novice users won't look there

other then that you can limit the number of records for a demo.

i think the registery way will wor because the user i want to give don't know about registry

but how?

 

[smig]

SaveSetting Name1 (I Put my name here), Name2 (I put application name here, password , password


password = GetSetting(Name1, Name2, password)



BTW - I use the same technique when I want to move data (like User ID) over many forms.
you can also use the GetSetting function in query.

 

[oliver916]

!
explain plz

 

[smig]

the SaveSetting function save a data into the registery.
the GetSetting function read the saved data from the registery.

let's say you want to save the number of times the application run.
your name is - Oliver916
your application name is Oliver916_App
the names you use are not importent but you must set them.

you will create a code similar to this, that will work when the application is invoked:

Dim NoOfTimesMyAppRun as String
 
NoOfTimesMyAppRun = GetSetting("Oliver916", "Oliver916_App", "NoOfTimes")
 
If NoOfTimesMyAppRun = "" Then ' --- No data stored = first time
[INDENT]SaveSetting "Oliver916", "Oliver916_App", "NoOfTimes", 1
[/INDENT]Else ' --- raise the counter by 1
[INDENT]SaveSetting "Oliver916", "Oliver916_App", "NoOfTimes", NoOfTimesMyAppRun+1
[/INDENT]End If

you can look for farther help in the HELP.