ODBC update errors

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Stewart Saathoff (stewarts_at_complete-networking.com)
Date: 06/11/04

  • Next message: Steve Jorgensen: "Re: ODBC update errors" 
    Date: Fri, 11 Jun 2004 10:55:41 -0500

    Hello Everyone,

    I have an MDB file that contains Forms and Reports that link to a SQL
    Database via ODBC. I have no problems adding records, but when I update
    them, I receive an error stating:

    Write Conflict

    This record has been changed by another user since you started editing
    it....

    Does anyone know how to resolve this? I tried changing the subforms to
    requery the parent after an update occured, but that had no effect on the
    issue.

    Any help would be appreciated.

    Thanks,
    Stewart

  • Next message: Steve Jorgensen: "Re: ODBC update errors"

    Relevant Pages

    • Re: Faircom c-Tree Server vs. Relational DBMS
      ... Our products were very reliable in terms of how the database ... SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management ...
      (comp.databases)
    • Re: Sybase Source. What "data flow source" to use?
      ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
      (microsoft.public.sqlserver.dts)
    • Re: Sybase Source. What "data flow source" to use?
      ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
      (microsoft.public.sqlserver.dts)
    • Re: Sybase Source. What "data flow source" to use?
      ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
      (microsoft.public.sqlserver.dts)
    • Re: How to import/export D3-NT data to MS SQL?
      ... dumb dumb dumb dumb dumb ... They had a million donar database and a 1.5M donation ... Every night they were trying to update SQL with the data from ... We are using Crystal Reports ...
      (comp.databases.pick)