current users?

[gsc_81]

Hi All. I've inherited an old db that frequently needs repairing. Does anyone know of coding that will check to see who is currently using a db so that we can have them logout and repair the db? Right now we have to go desk by desk. It would be lifesaver to go straight to the source.

thanks

 

[24sharon]

maby its can help u

good luck!

 

[ghudson]

You can open the record locking file [*.ldb] with Notepad or Wordpad. Set a file association to the file type .ldb and then you can easily open any .ldb file directly from Windows Explorer. All user names [computers] found in the .ldb file will have to log out before your can compact it. If everybody states that they are out then all users [computers] found in the .ldb file will have to reboot their PCs to disconnect their attachment to the database in question.

 

[gsc_81]

Thanks

Both answers helped. I was reminded that we are running Citrix servers so all resonses are coming back Admin with the various server names. It looks like creating a separate module with VB coding is the answer. Thanks again for the info.

Time to hit the books once again.