A client has an issue with appending from another table in the same database container.

They've had the same program for years--it zaps the records from mydata97, and then appends from mydata10. It does this for a series of tables in their database--around 60. It's to populate a sample company with their live data. All of a sudden, we're getting the following behavior:

After it appends, it goes to close the file or use another file, and we get:

Error writing to file

And the table usually corrupts itself.

Any ideas?

JR