Hi,
Bit of a strange one.
One of my SQL tables has stopped being updatable when viewed though a linked table in access. When i change some data directly in the table I get a write conflict.
When viewed in enterprise manager it is updatable.
It is possible to add new records in access and these are then updatable but any of the old records remain untouchable.
Really need to get this sorted as soon as possible so any help would be greatly appreciated!!
Mark.
Bit of a strange one.
One of my SQL tables has stopped being updatable when viewed though a linked table in access. When i change some data directly in the table I get a write conflict.
When viewed in enterprise manager it is updatable.
It is possible to add new records in access and these are then updatable but any of the old records remain untouchable.
Really need to get this sorted as soon as possible so any help would be greatly appreciated!!
Mark.