It looks like you have to Select the Unique Record Identifier. When I do this manually it opens it up to add records.  I was wondering how to do this with vba?

I have to quit asking these questions then answering them myself. You have to go into the SQL Management Studio then right click on the table then select the primary key on the SQL side. Otherwise it looks like everything is working fine but it wont let you update records.

CREATE INDEX <:YourIndexName> ON <YourTableName>(<YourFieldName>) WITH PRIMARY

Sometimes speaking them out loud can help solve a problem 🦆