R
Reggie
Hi and TIA. I have a backend db on my server. I often want to compact &
repair it, but cannot due to not being able to delete the ldb file. I have
a procedure from my frontend that checks logged on users. It indeed states
that several people are logged on when in fact I know that no one is. Why
is it showing them still logged on and how can I force them out so that I
can compact & repair the backend? I have a procedure that kicks everyone
off, but even running this I run into the same issue. I know I can copy the
backend to a new location, compact & repair, and re-establish the linked
tables, but that doesn't solve, explain or prevent this from happening. Any
advice is appreciated. Thanks for your time.
repair it, but cannot due to not being able to delete the ldb file. I have
a procedure from my frontend that checks logged on users. It indeed states
that several people are logged on when in fact I know that no one is. Why
is it showing them still logged on and how can I force them out so that I
can compact & repair the backend? I have a procedure that kicks everyone
off, but even running this I run into the same issue. I know I can copy the
backend to a new location, compact & repair, and re-establish the linked
tables, but that doesn't solve, explain or prevent this from happening. Any
advice is appreciated. Thanks for your time.