>>How do you provide pack database routine inside a program? I've tried following which doesn't seem to work.
>> CLOSE DATABASES ALL
>> OPEN DATABASE mydb EXCLUSIVE
>> PACK DATABASE
>>When I check after issuing the CLOSE DATABASES ALL using DBUSED(), the mydb database seems to be still open. Then, OPEN DATABASE mydb EXCLUSIVE seems to be ignored and finally an error message for PACK DATABASE shows up with "Database must be opened exclusively". Any suggestions?
>>
>>TIA
>>John
>
>John,
> Look at a product called stonefield database toolkit. It will give you the tools to do a btter pack and rebuild of your indexes and will fit nicely into most applications..
>
>Why write the code for this type of procedure, when they already have it... For $250, you get the source code and the ability to removed deleted records from your database without loosing all the RI code involved.
>
>Thanx!
>
>Tony Miller
>PTI

Tony,

Are you saying I can't PACK a database from my program and that I need to pay $250 to do this? I don't want to sound cheap and SDT might indeed be better for this and many other things but I can't imagine not being able to simply pack a database from VFP programs.

John.