Situation:

Creating a db where users are required to log in using a user name and password.

Question:

Is it possible to make the db 'time out' like after a 10 minute interval of inactivity automatically close the db and log the user out?

Is it possible to program the db to post a message to another user who may be trying to log into the db that someone, with the actual user name, is logged into the db and must exit before the other user can log in?

Bryan

Yes. Yes.

How much coding do you do?

There are a couple methods I can think of to get the system to shut down after inactivity. I am wondering if there is anyone with a more application specific method. The problem is deciding what constitues activity.

As for user security, how are you implementing this? It sounds like you will need to store values on the back end. In a user table, create credentials that is not linked to the front ends, so users can mess with it, and then set a value in the table when a user is logged on. If someone else tries to log in with the same credentials, just check the value, and if set to Yes, for example, prevent login and pop up a message box instead. Pretty simple if you are already doing security. How are you doing security?





mmcdonal

Well, coding, don't like it but seems like I am having to do a fair amount of it for what I'm trying to make this DB do. I found another member from the UA form who gave me a security DB that he did. I just edited it to add in some things that I want and now am in the process of adding in all my other tables, forms and queries.

If you send a copy, I could see how difficult it would be to add the notification and time out feature.



mmcdonal

How am I to send a copy?

Click on my name, then click send and email, then when I reply, you will know where to send it.

mmcdonal