Did you exclude VFP table files from virus scan?
>We have database files that have considerable amount of data. We have a routine that packs the tables of the database by looping thru the list of tables, use it exclusively then issue a PACK command. Note that all files are on my local drive. This is running the program from VFP8 IDE.
>
>This is the behavior I'm noticing:
>1. First round of PACK. Takes some time. This is understandable because VFP will actually cleanup the deleted rows.
>2. Second round of PACK. It seems to hang on several table, no rhyme or reason. During this round, it 'hanged' for approx 5 minutes on a table with 1 row. I noticed my HD is trashing.
>3. Third round of PACK. It 'hanged' for approx 5 minutes on a table with 1 million plus rows. I noticed my HD is trashing.
>
>Am I missing something here?
>
>* pseudo-code
>nDbfs=adir(myDbfs,'dbf')
>for nDbf = 1 to nDbfs
> use (myDbfs[nDbf,1]) exclusive
> PACK
> use
>endfor
>
--sb--