The newer ACARD SCSI IDE bridges don't have this limitation, the older ones do.

It's a limitation of the IDE controller that is on the bridge, not on the computer. SCSI doesn't handle drive sectors directly, and the limitation is with IDE's Logical Block Addressing Scheme. All SCSI sees is a big storage space with read/write and other instructions.

That's why SCSI drives are more expensive: All the disk controller activity is in the drive's electronics in SCSI, in IDE it's on the motherboard. Sort of like comparing full modems and Express Modems (and WinModems).