The number of records is not changed but the size of the table is. John
John Weller 01380 723235 07976 393631 I would very carefully document any changes, and the structure of any deleted fields, document the indices prior to deleting the fields; all so you can accurately recreate the database without the changes. I would run the apps and (assuming no source) add the fields and indices as it crashes based on the missing data. Q: why by eliminating fields are the number or records reduced? Note that I am a Foxpro/DOS programmer for my company's applications running under dosemu/ubuntu, not vfp. John _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/012c01d57963$98201420$c8603c60$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.