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