RE: Error 3197

Hi Jerry,

As seen from the other posts, you might have to do a bit more than that. You
might have to also make use of sql statements instead of the ms access
.edit/update routines.

Best Regards,
Dapo

-----Original Message-----
From: Jerry Schwartz [mailto:[email protected]] 
Sent: Wednesday, January 05, 2011 5:35 PM
To: [email protected]; [email protected]
Subject: 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]