RE: Error 3197

To be honest, last night I was floundering around trying to handle a lot of 
different problems, including wildly different behavior between my test 
environment and my production environments.

I've going to add timestamps today and see what happens. There's also a 
tick-list on the MySQL web site, although some of that sounds like it is trial 
and error.

Thanks.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: [email protected]
Web site: www.the-infoshop.com


>-----Original Message-----
>From: Oladapo Carew [mailto:[email protected]]
>Sent: Wednesday, January 05, 2011 3:05 AM
>To: 'Jerry Schwartz'
>Subject: RE: Error 3197
>
>Hi Jerry,
>
>Make sure you have a timestamp field in your tables. Also, are you using
>.edit/updates? If so, why not use sql statements??
>
>Regards,
>Dapo
>
>-----Original Message-----
>From: Jerry Schwartz [mailto:[email protected]]
>Sent: Wednesday, January 05, 2011 12:22 AM
>To: [email protected]
>Subject: Error 3197
>
>I've moved an Access 2007 application over to MySQL, using the ODBC connector
>5.1. When I try to update a record, as often as not I'll get a 3197. 
>Sometimes
>if I move back and forth in the table I can get around it, but I can't ask my
>users to go through various gyrations until they stop getting nasty messages.
>
>
>
>I've searched the web, and all I've found are complaints and suggestions that
>didn't work for me.
>
>
>
>I've tried toggling
>
>
>
>·         dynamic cursors
>
>·         return matched rows
>
>
>
>with no luck.
>
>
>
>In Access, all of the forms are designated to use Dynasets (inconsistent).
>
>
>
>Any suggestions? My job is more or less on the line.
>
>
>
>Regards,
>
>
>
>Jerry Schwartz
>
>Global Information Incorporated
>
>195 Farmington Ave.
>
>Farmington, CT 06032
>
>
>
>860.674.8796 / FAX: 860.674.8341
>
>E-mail:  <mailto:[email protected]> [email protected]
>
>Web site:  <http://www.the-infoshop.com/> www.the-infoshop.com
>
>
>





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