I have a converted Access application where I converted the backend to MySQL and kept the frontend(Forms/Queries/etc) in Access. One of my forms has a create duplicate button which in the Access Only version, it created a duplicate record and then refreshed the form with the duplicate record created. The table has an autoincrement field. All fine and dandy.
However, with the backend in MySQL, the same functionality generates a MySQL error 'Duplicate entry bla bla bla (#1062)'. I understand what is happening but don't know how to get around it. Just wondering if anyone out there has built an Access frontend with a MySQL backend and needed to duplicate a record, if so, how did you do it? Any suggestions would be great or alternate ways to do this.
However, with the backend in MySQL, the same functionality generates a MySQL error 'Duplicate entry bla bla bla (#1062)'. I understand what is happening but don't know how to get around it. Just wondering if anyone out there has built an Access frontend with a MySQL backend and needed to duplicate a record, if so, how did you do it? Any suggestions would be great or alternate ways to do this.
