Spurious record lock

[AndrewKKWalker]

The Delete Query is fairly straight forward

DELETE    FROM    TableToBackUp

The Append Query will depend upon whether you have an IDENTITY field
That is like an Access AutoNumber field

IF YOU HAVE NO IDENTITY FIELD

INSERT INTO   TableToBackUp
SELECT          BackupOfTable .*
FROM         	BackupOfTable

IF you have an Identity field then
You must name Each Field That exists in the Tables and also Add a Line to Allow insertion into the Identity Field

SET IDENTITY_INSERT TableToBackUp ON
GO
INSERT INTO  TableToBackUp
                 	(Field1, Field2, Field3, etc)
SELECT     	Field1, Field2, Field3, etc
FROM       	BackupOfTable

To be honest, you should not have to do any of this.
Once you have set the BIT Fields to 0, and then Updated the design
to have a default and Not allow zero's everything should be fine.

[Murgatroyd]

Thanks for your help. Writing default data to the three re-added bit fields and setting defaults for them resolved the issue, and the backup was not needed.