*** Urgent *** unable to update data in a view ...

[Guest]

I have linked a sql server view in access db.
I am able to update data in query analyzer, but I can't
update data in Access either directly or using a form.

How can I resolve this?

Thank you,
-Me

 

[Rick Brandt]

I have linked a sql server view in access db.
I am able to update data in query analyzer, but I can't
update data in Access either directly or using a form.

How can I resolve this?

Thank you,
-Me

When you create the link you should be prompted to identify which columns in
the view can be used by Access for a local unique index. If you skip that
step or provide incorrect column names then editing will not be possible or
will affect more rows than you expect.

If you perform the above correctly when creating the link the unique index
information will be lost should you ever refresh that link at a later time
and the link will revert to read only.

 

[Guest]

Hi Rick,

You are a saviour!!! It worked.

Thanks a lot,
-Me