Hi all.
I have a multiuser database distributed over a windows p2p network. This has
worked fine for 3 years. But my problem is this.......Every once in a while
the backend corrupts and needs to be repaired. This is not a problem in
itself but the lock file always stays in a state that says users are still
in the system and the lock file cannot be deleted until I reset the server
where the file resides.( I have another table in another database, which
when a boolean field is checked (yes) then the frontend(s) will close after
alerting the user that a problem exists). So the users are kicked out of the
system yet the lock file stays in the same state as when the backend
corrupted.
So my problem is my inability to delete this file so that I can compact and
repair the database.
Is this by design? Is there a way around my problem of having to reboot the
server to free the lock files state and delete it?
Please help. As I wrote code that closes everyone out, deletes the file and
compacts the backend, then allows users access again. But it will not work
because of my inability to delete the lock file unless I reboot the server
where the backend resides.

Help, help, help