From: John Foley
Date: March 23 1999 12:55pm
Subject: Write Conflict in Access97, ODBC 2.50.22
List-Archive: http://lists.mysql.com/myodbc/84
Message-Id: <4DF65804B870D11186AE00A0C992577E6E6B85@BOSTON-MAIL.pollak.com>
MIME-Version: 1.0
Content-Type: text/plain


	Hi all, I was wondering if anybody had come across this one yet . .
.

	I am using Access97 with ODBC 2.50.22 and MySQL 3.22.16a-gamma for
pc-solaris2.7 on i386
 (recently upgraded from 2.50.18 and 3.21.xx in an attempt to overcome the
same problem) and am unable 
to edit a row in a table (a mysqldump of which lies below). I can add
records, just not edit them.
	Access gives the error message:	
		"Write Conflict"
		"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."
		"Copying the changes to the clipboard will let you look at
the values the other user . . ." yada yada.

	This table should not be in use by anybody else, as the database is
in early development, 
and I'm the only developer.



	For reference sake, the database has a number of tables, all of
which have "NPB int(10)" as the primary key. 
Could this be caused by a lock on another table, given the identical key
names?






# MySQL dump 5.12
#
# Host: localhost    Database: PDP_Pub
#--------------------------------------------------------
# Server version	3.22.16a-gamma-log

#
# Table structure for table 'PPEActivity'
#
CREATE TABLE PPEActivity (
  NPB int(10) DEFAULT '0' NOT NULL,
  TeamLeadEngg smallint(5) DEFAULT '0',
  PPEStatus tinyint(3) DEFAULT '0',
  PhaseChg0_1 datetime DEFAULT '0000-00-00 00:00:00',
  PhaseChg1_2 datetime DEFAULT '0000-00-00 00:00:00',
  PhaseChg2_3 datetime DEFAULT '0000-00-00 00:00:00',
  PhaseChg3_4 datetime DEFAULT '0000-00-00 00:00:00',
  PhaseChg4_5 datetime DEFAULT '0000-00-00 00:00:00',
  POType tinyint(4) DEFAULT '0',
  PPEAction text,
  PPEActionDate datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (NPB)
);

#
# Dumping data for table 'PPEActivity'
#

INSERT INTO PPEActivity VALUES (5597,1,2,'0000-00-00 00:00:00','1999-01-01
00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00
00:00:00',2,'complete doublelock','1999-03-15 00:00:00');





				John

----------------------------------------------------------------------------
----------------------------------
	John T. Foley, CAD Systems Administrator
	Pollak Actuator Products Division, A STONERIDGE Company
	ph: 617-282-9550 x266	fax: 617-282-9058
----------------------------------------------------------------------------
----------------------------------