Attachment field making backend file very big

[MeldrethMan]

My client is using the attachment field in a Jobs table so much that the backend file is already close to 1 GB.

Without attachments it would be easy to append old records to an archive but this isn't possible when tables have attachment fields. Any advice on how to get round this? I could start by copying the backend to an archive, then deleting non-current records from the working copy. But how then could I archive some of these in due course, without having multiple archives?

 

[MeldrethMan]

I have now circumvented this problem by removing the attachment field and using links to the documents needing to be recorded against a Job.