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

Make sure you unlink/relink the MySQL table in Access after you make structural changes to the MySQL table before trying again. I personally have never found the TIMESTAMP to be necessary providing the MySQL table has a primary key defined.

John Bonnett 

-----Original Message-----
From: Markus Grossrieder [mailto:[email protected]] 
Sent: Thursday, 6 August 2009 10:03 PM
To: [email protected]
Subject: 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]