Hello plehsdeen.
Ok on the compaq page they say this
• Two drive bays open for expansion
So you should be OK just adding another drive, as for size, what size are you thinking of?
I don't think your OS will be a limiting factor (unless we're talking MASSIVE) your BIOS will most likely be the cause of any limit.
posting a question to Compaq would probably be your best bet regarding that.
Connecting should be a walk in the park, especially if you use it as a secondary disk drive.
Things you should check for.
• Two drive bays open for expansion (are they only for CD drives?)
Check around the floppy and existing HDD to see if there is any space for one, if you have to use a CD sized bay, then your going to need some long stand-offs or brackets to hold the drive, both should be fairly easy to find.
Check that your power supply has a spare 4 pin connector
Check your IDE cable for the existing drive to see if it has a spare connector on it, to connect the new drive to.
You can buy different IDE cables if you need one (with the extra port) but most IDE cable have the connectors for 2 drives as standard. You can also buy splitters for the 4 pin connector from your power supply.
Assuming a worse case, you will need brackets, IDE cable and power splitter, total price of about £5-10 at the max (on top of your drive)
Think all of the above may be a little too much info, or you are already prepared for that, the key question is the max size the OS can deal with, I couldn't find any restrictions on the web (quick search) the only restrictions I was aware of where relating to BIOS, as I suggested earlier, your best bet on getting actual info is to go to Compaq, fire off an email, and wait for them to get back to you (If you email them with the size disk you are looking at, they should be able to give you a straight yes or no)
I would guess that you could get a PATA drive up to about 200Gb without too much trouble
Hopefully one of the other members at daniweb has stuck a huge drive in one of these machines, and will be able to give you a definative answer.
SE