Software

Ask something
Discussion Locked

MS Acces / Kick out users of a database

0 helpful
4 replies

by ideafixer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have a client server database (Access 97, soon to be upgraded to 2000) set up with data on the network (Novell) and distrubuted forms databases stored on several local machines (98 & 2000).

When the network database gets corrupt requiring a repair to be ran, we cannot get everyone "out" of the database. The local "forms" DBs are linked to the network "tables" DB.

I just want to kick everyone out. I know clearing connection on the server can be done, but is there another way? Some code written in access maybe?

Thanks

4 replies

by don christner

I use a small utility from WWW.MERXSOFT.COM called ofl.exe. I setup various batch files and made shortcuts to them. Then anytime I need to see if anyone is connected, I select the shortcut to "show me who is connected to serverA". If I want them disconnected, I run the shortcut to "disconnect all users from serverA".

Look at the optional switches and you will see that this free little utility is very handy.

Don

by don christner

By the way, I mainly use this to disconnect people from my sales.mdb, same as you. I have never had any corruption from running this utility.

by ideafixer

Good solution for me. I was wondering, can you email me a text version of these batch files you have set up?

Specifically, the one that checks the users connected to the MDB and the one that boots them. I learn how to use stuff much faster through example.

I was trying to get your email but you do not have it on your profile. All I have to see is WoW you have answered a ton of questions!

Thanks!

This discussion is closed to new replies.