SQL - Access communication issues - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

SQL - Access communication issues

lessthanmelessthanme Posts: 17Member
I transferred tables from an Access database into SQL recently and am running into a problem. At first everything was working fine but I modified some of the tables in SQL and since then, a form in Access which is based on a table I modified will not let me enter any new information or edit existing information. I checked in Access everywhere I can think of checking and it appears everything is still set to enable editing/deleting/adding records. I'm assuming the problem is somewhere is SQL but I've never really used SQL so I wouldn't know where to even start. Any thoughts?


  • lessthanmelessthanme Posts: 17Member
    Okay I figured out the problem. Apparently Access doesn't like working with SQL tables if they are not keyed. So I selected a primary key and its working fine now.
Sign In or Register to comment.