Unable to update a linked table

  • Thread starter Thread starter Peo
  • Start date Start date
P

Peo

Hi

I have created a table in SQL Server. In my Microsoft Access database I have
then linked to the table in SQL Server. From Access it works well to insert
new rows, but some rows I can't update. If I translate the error message from
swedish into english it goes: "The record has changed by another user"
"This record as changed by another user since you started to edit. If you
save the record the other users changes will be lost.

If you copy to the clipboard you can inspect the other users changes. Then
can you maybe paste your changes again."

Anyone knows how to solve this problem? I want to be able to update the table.

Regards
/Peo, Sweden
 
Hi

I have created a table in SQL Server. In my Microsoft Access database I
have then linked to the table in SQL Server. From Access it works well
to insert new rows, but some rows I can't update. If I translate the
error message from swedish into english it goes: "The record has changed
by another user" "This record as changed by another user since you
started to edit. If you save the record the other users changes will be
lost.

If you copy to the clipboard you can inspect the other users changes.
Then can you maybe paste your changes again."

Anyone knows how to solve this problem? I want to be able to update the
table.

Regards
/Peo, Sweden
Click to expand...

Add a Timestamp field to the table on the server. Also, if it contains
bit fields set them to not allow Nulls. If that doesn't fix the problem
then it might be because the DataType of the primary key is one that
Access doesn't have a compatible match for (BigInt for example).
 
Thank you! You made my day! Problem solved.

Rick Brandt said:
Add a Timestamp field to the table on the server. Also, if it contains
bit fields set them to not allow Nulls. If that doesn't fix the problem
then it might be because the DataType of the primary key is one that
Access doesn't have a compatible match for (BigInt for example).
Click to expand...
 
Back
Top