Re: Cannot edit data in a Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would check the SQL Database table and make sure it has a primary key AND that it has a timestamp field (also known as a RowID). A field with the data type of timestamp is not a datetime field but a specific type of field that is not user changeable

From SQL Books on Line
TimeStamp is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes.

Mu understanding (could be wrong)
Access in consjunction with MS SQL Server uses the value to determine if a row has been changed or not. If Access does not see a timestamp field it cannot determine if the row it has fetched and is working on has been changed or not by someone else. So Access won't update the row.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Bruce wrote:
I am running Access 2007. I have written a query to a linked table (AssetMaster) that resides in a SQL Database (SQL Server 2005). I can enter or change data in a field for one record (it does not matter if I refresh, I still can only update this one record), but once I move from that record to another record to either update or enter new data I get the Write Conflict error message box. The save record option is grayed out and not available as one of the options. I have tried all of the suggestions listed in the online help, but to no avail. I need some help.

Bruce
.

Relevant Pages

  • Re: timezone warnings in 10g
    ... changing the data type in jtime from 'timestamp with time zone' to timestamp. ... SQL> set serveroutput on ...
    (comp.databases.oracle.server)
  • Re: Update Integrity
    ... check out BOL for timestamp ... timestamp is a data type that exposes automatically generated binary ... all updates to the data row also generate updates of the index. ... Database change management for SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: comparing two timestamp
    ... What are you trying to do with the timestamp data? ... In SQL Server, ... >Each array contains a timestamp from SQL database. ... >I can't figure out how to compare them in C#. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Relational database & OO
    ... And when was the last time you saw an RDB that stored a telephone ... The modern relational theory permits to store values of user-defined type: ... Neither do the relational model or SQL. ... Your comprehension of the SQL database performance is not good. ...
    (comp.object)
  • Re: LINQ Where 1=0
    ... The LinqDataSource control stores values for all primary keys ... Before LINQ to SQL updates or deletes data, it checks the values in view ... If the underlying data source contains a timestamp field that is ...
    (microsoft.public.dotnet.framework.adonet)