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

-----Original Message-----
>From: Bonnett, John [mailto:[email protected]]
>Sent: Thursday, August 06, 2009 7:13 PM
>To: [email protected]; [email protected]
>Subject: 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.
>
[JS] I agree with John on both points, except that you don't have to unlink
the tables: just use the link manager to refresh the link. I'm not even sure
you need a primary key, although I've never had any reason to test that.

Regards,
š
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
š
860.674.8796 / FAX: 860.674.8341
š
www.the-infoshop.com



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





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