Write Error with MySQL backend

[RAG2007]

Hi,

I'm creating a backend for my Access front end in MySQL, and am running tests. I am coming across the infamous "Write Error".

Here's an instance:
I open a form with a subform, and when I go to change a combo-box field, I get the Write Error. Once I click drop changes, I can go ahead and change the field without seeing the error again on any field on either the form or subform. I don't get the error when I change data in a field on the form itself, only when interacting with the subform (likewise, if I close the form or change to design mode, I get the write error).

I'm wondering maybe there's something I'm missing in my connection to MySQL, I am an absolute MySQL novice.

Thanks

Robin

[Dököll]

Hi,

I'm creating a backend for my Access front end in MySQL, and am running tests. I am coming across the infamous "Write Error".

Here's an instance:
I open a form with a subform, and when I go to change a combo-box field, I get the Write Error. Once I click drop changes, I can go ahead and change the field without seeing the error again on any field on either the form or subform. I don't get the error when I change data in a field on the form itself, only when interacting with the subform (likewise, if I close the form or change to design mode, I get the write error).

I'm wondering maybe there's something I'm missing in my connection to MySQL, I am an absolute MySQL novice.

Thanks

Robin

Have you tried using a passthrough query to achieve this?

Not sure how helpful this is, but I once usedAccess to speak with SQL Advantage/Sybase using a passthrough query with no issues, you'd need the fancy connection string which I cannot tell you off hand, might find it if you were to search deeper here, or a quick Google:-)

Hope you find what you needed!

Dököll

[RAG2007]

Thanks,

I'm using pass through query for record source on main form now. But two issues came up:
1) OBDC--Failed
2) I can't set a subform record source to a pass-thru query

And I'm still getting the write error.

[RAG2007]

Wierd enough, I redid all of the links, starting from a backup front end in Access, and I no longer get the OBDC call failed, nor do I get all the write errors.

Now the only write errors I get are when in code I do an rst.update. Working on that now.

Robin

Thanks,

I'm using pass through query for record source on main form now. But two issues came up:
1) OBDC--Failed
2) I can't set a subform record source to a pass-thru query

And I'm still getting the write error.