Does anybody know if Access has some type of a limit or something where it will delete records randomly? I have this issue and I'm not sure how to fix it. I thought either there was some type of size limit for the database or it is deleting maybe corrupt records. Not sure what's going on, any help would be great! I accidentally put this in the forms forum at first. oops.