Prog-master wrote:
Hi, I have a programs in access. Use a table in SQL serveur... Whit a
link in access. When a want write in this table, a receive a message
about the table: The recorset is not Updatable..
Do you know Why.
Probably no Primary Key defined on the server.
When you created a link and there is no PK on the server table you should
have been prompted to select the column or columns that Access should use to
build a unique index with. If you perform that step then the link will be
updateable. If you skip that step then the link will be read only. Of
course if you perform that step but you select the wrong column(s) then you
could end up trashing the data in the table when you make any edits.
The local index that Access creates to make the link editable will also be
lost if you later refresh the link.
Since every table in a proper database should have a PK, the best thing to
do is to modify the table on the server to add one and then create the link
over again. If the link is to a view then you might be forced to go with
the local index, but in that case be sure you know which columns should be
selected.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
