Hi,
I have a ms access table table which is linked to a mysql database table. I
have used a ms access form
to edit records. However, when I attempt to edit a record I get a write
conflict error in ms access. I am using MS ACCESS 2002. The error is 'the
record has been changed by another user since you started editi it.
If you save the record, you will overwrite the changes the other user made'.
The Save record button
is greyed out so I can't select that.
I am the only user on editing this record. I would really appreciate some
guidence on how I can go about editing the records.
The mysql database table has the design and field types below.
Thanks so much,
smriti
disability_orga nization_id mediumint(8) UNSIGNED No
auto_increment
address_id mediumint(8) UNSIGNED Yes 0
name varchar(200) Yes NULL
contact_name varchar(100) Yes NULL
contact_title varchar(50) Yes NULL
mandate text No
target_populati on text No
affiliations text Yes NULL
disability_asse ssment tinyint(4) UNSIGNED Yes 0
update_status tinyint(4) UNSIGNED Yes 0
changed tinyint(4) UNSIGNED Yes 0
last_updated date Yes 0000-00-00
abilities_magaz ine tinyint(4) UNSIGNED Yes 0
needs_checking tinyint(4) UNSIGNED Yes 0
approved tinyint(4) UNSIGNED No 0
added datetime No 0000-00-00 00:00:00
user_id mediumint(8) UNSIGNED No 0
community_id mediumint(8) UNSIGNED No 0
notes text Yes NULL
logo varchar(200) No
CAF_id mediumint(8) UNSIGNED Yes NULL