Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Fri Oct 15 09:42:38 CDT 2004
No...I didn't implement a transaction history. The login form just serves as a gentle reminder that users are not anonymous and that problems can be tracked down to the date/time and particular users who were logged in. An honest person therefore is more likely to approach me and let me know that they just accidentally deleted 10,000 records...rather than let me track down, confront and publicly implicate several potential suspects;) ...at least that's the plan;) ...it's been working so far;) Mark -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Friday, October 15, 2004 10:06 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Get user name Mark, what do you mean to keep people honest? Any way to relate the person logged to something actually done in the database? Susan H. Susan, I'm sending you a simple db (A2K, 208KB) that includes an automatic login/exit form, modules for computer name and user name, and a usys table that stores this information along with a date/time stamp. Notes: 1. Requires a DAO reference. 2. Login info is tracked regardless of whether the user exits from the login form or not. I basically just use it as a scare tactic to keep honest people honest. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com