>>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
>
>Try using the next command:
>Close database
>OPEN DATABASE mydb
>Use dbfname EXCLUSIVE
>Pack
>I think that you need each DBF in the DATABASE.
>
>Gerardo

Gerardo,

Thanks. Actually, I was thinking of doing just that as a last alternative. However, I was thinking of the easiest way to do and to maintain later since if I add or delete any tables later, I have to re-code the module. What I'm looking for now I guess is for someone to clarify to me why my commands don't work when it should in my opinion.

John.