RE: Error 3197

>-----Original Message-----
>From: Mike Nelson [mailto:[email protected]]
>Sent: Tuesday, January 04, 2011 8:15 PM
>To: 'Jerry Schwartz'; [email protected]
>Subject: RE: Error 3197
>
>A lot of work, but...
>
>Unbind the form, use classes, and do your writes through code.
>
[JS] Thanks -- I guess.

Actually, I'm running into the same error using just a tiny bit of code.

-----
    WKSql = "SELECT [TA_ID_Management].[ID number Lastly Taken] FROM 
TA_ID_Management WHERE (([TA_ID_Management].[ID Management KEY])=""" & WKKey & 
""");"
    Set myDB = CurrentDb
    Set Myqdf = myDB.CreateQueryDef("")
    Myqdf.SQL = WKSql
    Set Myset = Myqdf.OpenRecordset(dbOpenDynaset)
    Do Until Myset.EOF
        Myset.Edit
        Myset![ID number Lastly Taken] = WKMaxID
        Myset.Update
        Myset.MoveNext
        WKOk = True
    Loop
    Myset.Close
    myDB.Close
-----

Would using classes fix the problem? That seems bizarre.


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




>
>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]