I have a new DB copy from the old one. I find I get the same problem when I run this code. This form is a utility only used to change table to a backup or startup table.
I don't get any errors when this form runs and all seems to work, just the corruption in Sys files.
Thanks, Mad-Tom
Code:
DoCmd.CopyObject , PartsName_global & Now(), acTable, PartsName_global 'make a backup of PartsName_global
DoCmd.CopyObject , "tblPartsBackup" & Now(), acTable, "tblParts" 'make a backup of tblParts to tblPartsBackup
DoCmd.DeleteObject acTable, "tblParts"
DoCmd.Rename "tblParts", acTable, PartsName_global