Run time error '3420': Object invalid or no longer set.

[David44Coder]

I've changed to setting CurrentDB as advised, and set up to read the Drive Volume rather than the serial number.
As an experiment I tried .Edit instead of .AddNew and while it did the job, I'm still looking at the tables normalised
to see what's what and how it might work.