What network do the tables reside on? Are they flagged as read-only by any chance? Do all tables reside in the same directory? A user-rights issue maybe? Can you insert or add records outside the app manually? Not an exclusive use issue by any chance? Does the problem only occur in your app and no place else or anyway that you attempt to access the tables? What are the sizes of the tables, their indices, and their fpt files? Can you pack the tables successfully and the memo file too? What happens if rebuild the index tags from scratch?

Tracy

>Hi,
>
>Is it possible that a power fluctuation or spike could damage a Foxpro dbc to the extent that validate database does not show any problems and yet tables in the dbc will not accept 'inserts' or fire on insert triggers?
>
>This particular installation has handled over 45,000 inserts within the past 6 months and suddenly at a particular time just stopped accepting inserts on 2 tables within the dbc. The rest of the dbc and other tables seem to work as they should.
>
>Any help/comments would be greatly appreciated.
>
>Thank you in advance.
>
>Mike Mayo