Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
Hi everyone...This is the second time someone has put a password on our database. They've also deleted it once before. I have a database that has to be open to almost everyone. Daily call offs, etc are logged in here for 27 different departments. I can not set up users in this database because of problems in the past. Last night again, someone password protected the database so no one can get in....I have 5 days worth of backups...so it's really no big problem, however, we'd like to know who keeps doing this. I have created a form that looks at idletime and runs in the background. What it does is closes the database after 5 minutes of inactivity..(had to create this because of problems too) what I've done is created a network userID function and put 2 textboxes on this form as well. One text box brings up their ID, and the other is the current date and time. What I'd like is for this information to be exported to an excel spreadsheet everytime someone logs into the database. That way, we can see who the last one was to use it...I can do that, however, I'd like it to keep a running log of users...not keep replacing the spreadsheet. Does anyone have any idea how to do this, or suggestions as to a better way of keeping track of users?
Sorry this is so long winded...
Thanks for any help.
Dave
Sorry this is so long winded...
Thanks for any help.
Dave