RE: Error 3197

A lot of work, but...

Unbind the form, use classes, and do your writes through code. 


Mike Nelson
Seattle, WA
website: http://www.feman.com
blog: http://thefeman.blogspot.com


-----Original Message-----
From: Jerry Schwartz [mailto:[email protected]] 
Sent: Tuesday, January 04, 2011 2:22 PM
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]