MS SQL Server ODBC - Unable to update text field

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Unable to update text field

Max Yaffe

2006-02-14, 11:23 am

Dear Group,
I'm using Access with SQL Server via ODBC. One of the fields in a
table is defined as datatype Text. I'm running into a problem
updating data in this field in Access. After I write data into the
field and try to save the record, I get an error "This record has been
changed by another user..." with buttons to Copy to Clipboard, Drop
Changes, and (grayed out) Save Record. I'm the only user on this
database. Other non-text fields can be written. What's going on?

Max

Sponsored Links