New record possible but update fails

  • Thread starter Thread starter Neil Jarman
  • Start date Start date
N

Neil Jarman

Hi,

This was also posted to microsoft.public.access.odbcclientsvr

I have experienced this problem from time to time.

In access 2000 or 2003 I have a linked table (to SQL 2000) which was working
fine.

I have added an extra column to the table, and now an existing record not
updateble.

I can still add in new records, but if I edit an existing one I get the
message:

Write Conflict - This record has been changed by another user ... Copy or
Drop

This is despite the fact that no-one else is actually using this data at the
time.

Obviously, the data is editable in EM and permissions are correctly set for
the table.

If it's relevant - each record was 294 bytes in length before, now 295 (I
added a bit field) and there are 2344 records in the table.

Please advise,

NEIL
 
Neil said:
I have added an extra column to the table, and now an existing record not
updateble.

I can still add in new records, but if I edit an existing one I get the
message:

Write Conflict - This record has been changed by another user ... Copy or
Drop

This is despite the fact that no-one else is actually using this data at the
time. .. . .
(I
added a bit field)
Click to expand...

Ensure the table has a primary key, a timestamp column and any Bit data type
columns have a default value, which is _not_ NULL. If this is an MDB file
and you need to make any changes to this SQL Server table, drop the link,
make the changes, then create a new link so that all new properties will be
saved in the link information in the Access file. For more information,
please see the following Web page:

http://support.microsoft.com/default.aspx?id=280730
 
Back
Top