By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,492 Members | 1,289 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,492 IT Pros & Developers. It's quick & easy.

Write conflict error w/ linked tables

P: n/a

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_organization_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_population text No
affiliations text Yes NULL
disability_assessment 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_magazine 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








Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.