@ImpossibleUmbrella Are you possibly hitting this problem?
https://www.klennet.com/notes/2018-04-14-usb-and-sector-size.aspx
@ImpossibleUmbrella A lot of USB adapters expect the drive to use LBA addressing mode.
An early 40MB IDE drive is probably (make that almost absolutely) only going to use CHS mode for addressing the sectors. The only way to work with that drive will be to put it on a real IDE controller, not a USB to IDE bridge.
@ImpossibleUmbrella Another thing to be aware of is that even on modern drives, a lot of these adapters don't have power supplies that are adequate for spinning an IDE or a SATA drive. Even the ones that supply external power and are not just powered off of the USB port.
I've run into that problem regularly. My newer USB 3.0 adapter with external power won't spin up a SATA drive, but my older USB 2.0 "dock style" adapter will. It's irritating. I have a variety so that I can get one working.