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]