Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Limiting Password
- Thread starter 1JohnnyV
- Start date
psemianonymous
Programmer
There is no foolproof way to do this. You can put some code in your startup procedure and pull the password for the current date from a table. Obviously if you can read the tables, every one else can too...so any solution you come up with will only protect against casual intrusions.
Again, there is NO good way to do this.
--
Find common answers using Google Groups:
Corrupt MDBs FAQ
Again, there is NO good way to do this.
--
Find common answers using Google Groups:
Corrupt MDBs FAQ
Hmm. I just thought of a couple of pretty decent ways...
Make a form that allows the user to change his password without using the security menu item (there's code for this in the security faq, which you can get from MS or from my site). Put something in the code that records the user name and the date in a table every time the user changes his password (probably just update the date if the user is already in there, but you could make a history table if you wanted).
Then do one or both of the following:
1) Write code that fires when an admin logs in to go through that table and blank and then set-to-some-random-string the password for each person who hasn't updated their password in the past XX days.
2) Write code that fires each time a user logs in that, if they haven't changed their password in XX days, blanks their password and set it to some random string and then kicks them out of the database.
Shouldn't be that hard to set up, if you just crib the code from the faq.
And sounds like a nice set of code to own.
If you write it, I'd love to see a copy of it posted here.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Make a form that allows the user to change his password without using the security menu item (there's code for this in the security faq, which you can get from MS or from my site). Put something in the code that records the user name and the date in a table every time the user changes his password (probably just update the date if the user is already in there, but you could make a history table if you wanted).
Then do one or both of the following:
1) Write code that fires when an admin logs in to go through that table and blank and then set-to-some-random-string the password for each person who hasn't updated their password in the past XX days.
2) Write code that fires each time a user logs in that, if they haven't changed their password in XX days, blanks their password and set it to some random string and then kicks them out of the database.
Shouldn't be that hard to set up, if you just crib the code from the faq.
And sounds like a nice set of code to own.
If you write it, I'd love to see a copy of it posted here.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Affordable Development, Professionally Done
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status
Similar threads
- Locked
- Question