By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Write Error with MySQL backend

P: 34
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
Jan 10 '08 #1
Share this Question
Share on Google+
3 Replies


Dököll
Expert 100+
P: 2,364
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
Jan 11 '08 #2

P: 34
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.
Jan 11 '08 #3

P: 34
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.
Jan 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.