A rivetable adhesive for use in a joint between dissimilar materials, comprising a liquid epoxy resin, an expoxidized polysulfide, a flexibilizer, a solid epoxy CTBN adduct based upon bisphenol A, a phenoxy resin, an impact modifier including methacrylate-butadiene-styrene, a curing agent; and a blowing agent. The adhesive finds particular suitability for use in riveting aluminum panels to steel structures, such as for forming automotive vehicle roof structures.