RE: MySQL/ Access newbie problem: Access DB not editable - SOLVED!
"Jerry Schwartz" <[email protected]> Fri, 7 Aug 2009 10:08:26 -0400
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | The Infoshop by Global Information |
| Message-ID | <[email protected]> |
>-----Original Message----- >From: Ian Masters [mailto:[email protected]] >Sent: Thursday, August 06, 2009 8:59 PM >To: Markus Grossrieder >Cc: [email protected] >Subject: Re: MySQL/ Access newbie problem: Access DB not editable - >SOLVED! > >Markus and everyone who made suggestions. > >> 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 > >I thought I had tried the TIMESTAMP fix but I looked at my table and >although I >had created a field named Timestamp, it was set to the wrong data type. >After I >changed the type to TIMESTAMP and re-imported my data, I was able to >edit it! > [JS] I believe you have solved your problem accidentally. You do not need a TIMESTAMP field to edit MySQL data from Access. I suspect that re-linking your table is what actually solved the problem. 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 -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]