>On one of our applications, we have various users who use the software on laptops.
>
>Upon checking out an index problem on one of the machine, their DBC file was 80MB.
>
>Can anyone tell me why it would reach such a volumn - it is normally a few 100K.
>
>Thanks
>Kev
If you create, modify or remove local/remote views, your DCT (memo file associated with DBC) will grow as any normal memo file would.
Open the database exclusively and modify it. From the VFP menu select Database - Clean Up Database. If this doesn't clean up the excess space, close the database and open it as a table (i.e. use mydatabase.dbc exclusive). Then issue a pack in the command window. This should do it.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao