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

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

I posted this to the forums as well. I hope I'm not cross-posting.

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


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]