Field locked

Dear all,
We've got a very strange issue and we can't work out so any help will be
welcomed. Involved Access and Sql Server.
From Access db a specific field of a row is not be able be updated for the
developer (by hand) as well as by the end-user.
But the rest ones (other fields in the same row, below rows, and so on, no
problem at all)
That table is linked to Sql Server. Nothing amazing with that.
Message is the following: "Writing forbidden, that field has already locked
by another user". In a fact, nobody else is in that moment working with the
Access db or Sql Native info.
Looking for any clue with sp_lock, select object_id and analyzing the
problem from another workstation doesn't give us any solution.
Does anyone ever experienced this problem?
Thanks for any input and regards,Could it be that the column in question is referenced by a constraint in
SQL.
The following should tell you :- EXEC sp_helpconstraint tablename
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
> Dear all,
> We've got a very strange issue and we can't work out so any help will be
> welcomed. Involved Access and Sql Server.
> From Access db a specific field of a row is not be able be updated for the
> developer (by hand) as well as by the end-user.
> But the rest ones (other fields in the same row, below rows, and so on, no
> problem at all)
> That table is linked to Sql Server. Nothing amazing with that.
> Message is the following: "Writing forbidden, that field has already
> locked
> by another user". In a fact, nobody else is in that moment working with
> the
> Access db or Sql Native info.
> Looking for any clue with sp_lock, select object_id and analyzing the
> problem from another workstation doesn't give us any solution.
> Does anyone ever experienced this problem?
> Thanks for any input and regards,|||Yes, it have constraints but no in the affected field.
Although I would remark that the datatype is 'text'
"Ryan" wrote:

> Could it be that the column in question is referenced by a constraint in
> SQL.
> The following should tell you :- EXEC sp_helpconstraint tablename
> --
> HTH. Ryan
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
>
>