Logging out users to database

[mfiedler]

Is there a way in Access to logout users from a database in order to make updates without having to setup a FE/BE situation? My company is using Novell Client 4.90.0.0 SP1a. I have read some logs where you choose File --> Open (exclusive), but I do not have that option (using Access 2000). Any other thoughts?

 

[KenHigg]

I think the most common way is to have a hidden form that stays open all the time where the timer event is set up to constantly check a var. If the admin sets the set the var to a specific value, the db automatically closes (or advises the user to close the db).

 

[selenau837]

I've attached a timer form like the one in my database.

On the on timer event on all of my forms, I have it set to call this form. The user then can decide whether to answer. I belive there is a timer on this form, so that if the person doesn't respond yes or no, it automatically logs them out. If not, you can easily set that up.


Good luck
selena

 

[mfiedler]

Timer idea

Thanks for the timer Selena. I have implemented it to cut down on the number of active users, which makes it easier to get remaining active users removed from the database when necessary.



Matt

 

[selenau837]

Thanks for the timer Selena. I have implemented it to cut down on the number of active users, which makes it easier to get remaining active users removed from the database when necessary.



Matt

You are very welcome, glad I could help you out!

 

[ghudson]

You are asking for trouble if you do not split your db.

 

[selenau837]

You are asking for trouble if you do not split your db.

ghudson, My database use to be split. However when it was split it corrupted almost daily. Once it was put back together, we've no longer had corruption problems.

I don't know why, perhaps it was a fluke, but in my case the non-split database is better.