John, check the CLOSE command in the VFP help. You will then need to re-open the file in exclusive mode to perform the PACK. No other user will be able to gain access while you have the file open in exclusive mode.
>Ok, that makes alot of sense, however, now I'm getting a message that the file is currently open and the delete cannot be executed. How can I close the db connection so that I can perform the pack?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
