PivotTable Insert, Update, Delete of SQL Data doesn't work

[Howard]

Hi
I seem to be missing something important!!!
In the Component Toolpak is says u can update any relational source. I can
only get it to work for Access Dbs not MSSQL Server tables!!!
Any ideas??
Thanks

 

[Howard]

I discovered that u can only edit the table when it has a primary key