How To Locked A user

[haidsm0a]

hi any body help me
i needed some code
i want a how to locked a user Account
if any user can't loging a log days the account is Automatic Locked aftere some days
any body help me
thanks

 

[ColinEssex]

If your database is on a network, I would suggest picking up the users network name. Match this against a table of users which will also include a date-logged-in field.
Then you could have a query or code which runs every time the database is open which checks the difference between their 2 dates (last-logged-in date and today). If the difference is greater than say 3 days (or whatever) then a message comes up and says they can't go any further and shuts the database.

I suppose you could have a status field as well that switches between yes/no and use that.

As you can tell, I thought up this just very quickly off the top of my head, and I'm not really awake yet!! but it'll give you an idea perhaps.

Col

 

[haidsm0a]

yes My Dear Friend on The Network
if you have any code or Samples Please Send Me


Thanks
No any Body Help Me il stil Wait Mybe Any Body Help Me
Thanks

 

[haidsm0a]

Locked

oh
i don't like this site very bad site
no any body help there
i think there no good programmar
Please used other site there good programmar
http://www.utteraccess.com/index.phpwww.utteraccess.com/index.php

thanks

 

[Rich]

Re: Locked

oh
i don't like this site very bad site
no any body help there
i think there no good programmar
Please used other site there good programmar
thanks

There are plenty of good programmers here, they don't answer on demand and you could have found the answer by using the search function. You just couldn't be bothered

 

[haidsm0a]

Locked

okay you know how many days i Post this topic a log days but can't give any body anser me
same topic post other site i recevied answer
so tis mean other site is good
thanks

 

[Rich]

It's an extended holiday period here and the weekend. Still since you found the answer elsewhere, I suggest you take your camels and stay there

 

[haidsm0a]

Locked

Okay

 

[haidsm0a]

User Lock

Oh Very BAd no any body Help Me Really Very Bad
Her no Good Programmar

 

[=TB=]

Re: User Lock

Oh Very BAd no any body Help Me Really Very Bad
Her no Good Programmar

So you said previously

oh
i don't like this site very bad site
no any body help there
i think there no good programmar
Please used other site there good programmar
http://www.utteraccess.com/index.phpwww.utteraccess.com/index.php

thanks

Even though Colin had replied with

If your database is on a network, I would suggest picking up the users network name. Match this against a table of users which will also include a date-logged-in field.
Then you could have a query or code which runs every time the database is open which checks the difference between their 2 dates (last-logged-in date and today). If the difference is greater than say 3 days (or whatever) then a message comes up and says they can't go any further and shuts the database.

I suppose you could have a status field as well that switches between yes/no and use that.

As you can tell, I thought up this just very quickly off the top of my head, and I'm not really awake yet!! but it'll give you an idea perhaps.

Col

And I now reply with the only word that springs to mind

Tool

 

[haidsm0a]

Locked

yes My dear Friend if you have nay code and samples pls give me thanks

 

[haidsm0a]

Locked

hi i needed some help any body help me
thanks

 

[ColinEssex]

Re: Locked

hi i needed some help any body help me
thanks

Listen - either you want a reply or not.
I thought you said this site was bad and that utteraccess was better, why haven't you got a reply from them if they are so good?

The members of this forum are usually at work and do not have much time to spend waiting around for people to post problems. You request would have been answered if you were not so impatient. This only alienates the members here so they feel less inclined to help you. Plus as Rich said, many members are on extended holiday from the xmas/new year period.

Have you done a search yet? your problem may have been covered before.

Col

 

[haidsm0a]

Locked User

so i know what you want to do