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!


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.