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

Do you have primary key id (unsigned autoincrement) in your MySQL table?
If not try to add it.

2009/8/4 Ian Masters <[email protected]>

> 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]
>
>


-- 
Если есть трудное дело, поручите его лентяю: он найдет более легкое решение.