RE: MySQL/ Access newbie problem: Access DB not editable - please help
"Bonnett, John" <[email protected]> Mon, 10 Aug 2009 08:14:46 +0930
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Yes, you are right I forgot about refreshing links. You do need some way Access can uniquely identify rows in the server tables so it can reliably update them. You probably do not strictly need a primary key, just some combination of columns that uniquely identifies the rows. A primary key is the simplest way of doing that. A timestamp will also provide a unique column for this purpose. John Bonnett -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Friday, 7 August 2009 11:10 PM To: 'Bonnett, John'; [email protected]; [email protected] Subject: 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]