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

I had some problems as well if there was no field of type TIMESTAMP in the 
table. Try to add one (call it 'timestamp') and see if that helps

regards,
Markus

----- Original Message ----- 
From: "п▓п╩п╟п╢п╦п╪п╦я─ п▓п╩п╟п╢п╦п╪п╦я─п╬п╡п╦я┤" <[email protected]>
To: "Ian Masters" <[email protected]>
Cc: <[email protected]>
Sent: Tuesday, August 04, 2009 11:45 AM
Subject: 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]
>
>


-- 
п∙я│п╩п╦ п╣я│я┌я▄ я┌я─я┐п╢п╫п╬п╣ п╢п╣п╩п╬, п©п╬я─я┐я┤п╦я┌п╣ п╣пЁп╬ п╩п╣п╫я┌я▐я▌: п╬п╫ п╫п╟п╧п╢п╣я┌ п╠п╬п╩п╣п╣ п╩п╣пЁп╨п╬п╣ я─п╣я┬п╣п╫п╦п╣.


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