I wouldn't use Liquid Nails. But, for what it's worth, regular silicone aquarium sealant, though it does not bond well to acrylic, is fine for some situations.
I'm using a 20g tall as a sump, and attached 3 full-width pieces of acrylic to serve as baffles/bubble trap. After doing a freshwater...