Haunted Nights (1993)

Wacky private eyes Sam and Roscoe travel to Scotland after they are recruited by a shady woman to investigate the death of her grandfather who may have been murdered and her family members are part of the conspiracy.