CAN'T Update TABLE Linked from MS ACCESS to SQL SERVER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am using SQL SERVER 2000 and Access 2000. We have a set of tables in SQL
SERVER that are linked into our ACCESS Database(NOT AN ADP). We have ONE
table that will not allow updates in Access (SQL SERVER is fine) ? IT always
gives the error -

"The Record has been changed by another user since you started editing it,
if you save the record you will overite the changes the other user has made.
coping to the clipboard will let you look at the values the other user
entered then paste you changes back in if you decide to make changes"

Three bottons are shown Save, copy to clipboard, and Drop Changes
The SAVE button is DISABLED, and if Chose copy Right click PAste is disable
(also ctrl-v does nothing)

Why is this happing - it does not matter what user is using the system it
does not seem to matter what ACCESS security is set at or SQL secruity (I AM
'SA' and is does it to me)

The only thing I can think of is that this table has a compound primary key?
Would that matter?

Thanks
 
The problem is that Access' optimistic locking is confused, and there are many
possible reasons for it. In general, adding a TIMESTAMP type column to your
table, and re-linking from Access will solve your problem, because Access will
then use just the TIMESTAMP column to find out whether the record was changed
by another user rather than the more error prone method of comparing the
original values of all the columns in the table.
 
Steve Jorgensen said:
The problem is that Access' optimistic locking is confused, and there are many
possible reasons for it. In general, adding a TIMESTAMP type column to your
table, and re-linking from Access will solve your problem, because Access will
then use just the TIMESTAMP column to find out whether the record was changed
by another user rather than the more error prone method of comparing the
original values of all the columns in the table.
Click to expand...
 
Back
Top