Your macros likely need to be rebuilt because a parameter they use no longer exists. We are talking macros here and not vb code, right? Most of us don't use macros but we can sometimes advise.
I confess I've never dealt with SP beyond doing automation from Access but this doesn't sound right
but used the SSN field as the primary relationship
In Access alone, the PK field should be the autonumber field. It's usually accepted that PK values should never be meaningful data. Maybe that's not what you meant by primary relationship as I'm not sure there is such a thing. Relationships between PK and FK fields are not usually described as primary, secondary or anything else like that.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.