Access linked table frustrated me on having primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I do not assign a PK on a linked table, I cannot use DoCmd.RunSQL or to
update the table or directly update the record in ADP. It warned me it was
not updateable.
But I can edit the record in SQL Server.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2a5a&dg=microsoft.public.access.modulesdaovba
 
I don't see why that should be a problem. Every table should always have a
primary key.
 
Back
Top