By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Table sql in acces is not updatable

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
Br
Rick Brandt <ri*********@hotmail.com> wrote:
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.


<>

Also, make sure all bit fields have a default value and more obviously
that you have permission to update the table.

In some cases the ODBC driver only supports read-only but this should be
ok for SQL7.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.