Why are some tables read-only in an ADP?

[Guest]

I've created a couple of Access Data Project files - practicing upgrading my
access databases into SQL server databases.

The problem I have with these ADP files is that I can only write to some
tables - and there doesn't seem to be any rhyme or reason why.

I've made sure that the permissions are all checked for my integrated
windows user, but it doesn't seem to make any difference, because the tables
that I can write to aren't set any different.

What is the secret to creating a fully functional adp?

 

[Sylvain Lafontaine]

Usually this problem comes from a missing primary key.