I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row, so I end up having to copy and paste all records into Excel (it won't let me export), deleting the #Error row, then importing it back into Access. It is a pain because I lose the data from that row...

I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row, so I end up having to copy and paste all records into Excel (it won't let me export), deleting the #Error row, then importing it back into Access. It is a pain because I lose the data from that row...