MySQL/ Access newbie problem: Access DB not editable - please help

[Ian Masters]

OK, I'm very new to this so please be patient.

I've been using MySQL for about a month using the command line and phpMyAdmin and that hasn't been to much of a problem so far.

I want to be able to access the MySQL DB from Microsoft Access and add/alter information. So ...

I downloaded and installed the ODBC driver and made the connection between Access and my MySQL DB. All well so far.

Then I imported data into my MySQL DB from a csv file. That went OK. However when I access the data from Access I can view it but I can't add a record or make alterations. When I try to do it an error box pops up. I'd like to tell you exactly what it says but I'm working in a Japanese environment and I can't find the English error message on the Net, but the gist of it is as follows:

Error window title: Data Conflict
Error Message: "This record is being amended by another user. Select 'Save Record', ignore the other user's amendment and update your amendment"

There's more in the error message underneath but I can't even select the 'Save Record' dialogue box as it's greyed out.

The strange thing is that I can amend data on other tables and those amendments are reflected in the MySQL DB.

I have no idea what the problem is.

If you made it this far, thanks for reading and any advice from a more seasoned MySQL/Access user would be very gratefully received.

Ian

MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP Pro SP3