D
Dr Byte
We deal with fairly large data bases with numerous tables. Occasionally a database will corrupt and is unrepairable with the compact and repair tool from Microsoft. On thoses occasions we unload the data from the damaged table into an .asc text file and them import the txt file to an empty table. That is until now. The problem became evident when persons searching the table under criteria dealing with one field in a record encountered the error message "invalid argument" and then all fields on the form turned to #NAME? instead of valid data. When we try to export the damaged table to a .asc file we get the export text error message "record is deleted". Upon pressing OK the error message is "An error occurred trying to export data from table 'OE'. The data was not imported". Does anyone have any suggestions as to how we can save the data on the 10,000 records in this table. We have tryed exporting and importing the table. The old table will not import and gives the same "invalid argument" error message.l