When I reconnect the tables to to the SQL Database manually then everything works fine. If I connect the tables through VBA like the on lesson 5 then it doesn't allow me to add any new records. Not sure what is going on?
Jeremy HansenOP
@Reply 4 years ago
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?
Jeremy HansenOP
@Reply 4 years ago
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.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.
