Write Conflict In Access Table linked to SQL

[u104741]

I have a problem where by i cannot edit any records in a particular table within Access. The table is a linked SQL table. I get the Write conflict error mesage telling me that " this record has been changed by another user...etc... ???

If i open the table in Enterprse Manager i can edit the records ok.
I have checked that the table has a key field in SQL as i understand that can be a problem in Access, but what else could it be??

I hope some of you good people can help me.. its driving me nuts!!

G

 

[cmmrfrds]

Is this an ODBC linked table from sql server? What are all the data types listed in the select statement? For example, varchar, int, bit, tinyint etc... Does the table have an unique index that you are trying to update? Can you paste in your select statement.

 

[u104741]

thanks for pointing me in the right direction... from your message i got suspecious that maybe i had a funny data type or somthing similar.. So starting removing fields one by one, re-attaching the table to my mdb file via ODBC and re-testing a record update.

I found it did not like a field that had a 'bit' data type as, as soon as i removed that field it worked... adding back the field and it failed again... ???

I have now recreated my table from scratch, with the 'bit' field and it is now ok???? most bizzare...
cheers
G

 

[cmmrfrds]

You hit on it, that was what I was looking for. The bit data type does not map correctly through odbc. If you really need the bit field you will need to bypass odbc or have the sql server dba change to another field type. You can retrieve the records with ADO and won't have the same problem, or use a pass through query which will bypass odbc.

 

[cmmrfrds]

A little more background.

thread700-571073

thread700-677301

 

[u104741]

cheers ill keep in mind.. thanks for your help.