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

Vladimir

Thanks for the reply.

I tried that but it didn't help.

I can add new entries to the Access table which are reflected in the 
corresponding MySQL table but I can't amend any data that I have imported from 
the original CSV file.

Ian

> 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] <mailto:[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]
> 
> 
> 
> 
> -- 
> ���� ���� ������� ����, �������� ��� ������: �� ������ ����� ������ �������.




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