Re: Access application with linked table to MSSQL server, data not updateable

On 17 Aug 2005 07:34:53 -0700, dadofgage@xxxxxxxxx wrote:

>
>I have an application that was written in access and it is linked to
>data on a microsoft SQL server.
>
>I have no problems getting the data out of the database but if I want
>to update the data, I get an error.
>
>So now I sit in the list of tables in access and double click on the
>table name to view the data in data*** view. No problem.
>
>If I change anything and move to another record, I get the 'this record
>has been changed by another user since you started editing it. if you
>save the record, you will overwrite the changes the other user made.'
>There is no one else in this database except for me.
>
>So the question comes, what is set up incorrectly that I cannot have
>this data editable?

The cause for this is usually the use of a data type on the server side that
cannot reliably be checked for equality using a SQL statement (such as a real
number). The solution is usually to add a TIMESTAMP column to the server-side
table, so ADO can use that field as the definitive indicator of whether the
record has been changed by someone else.
.