469,608 Members | 2,178 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,608 developers. It's quick & easy.

Inserting records to MYSQL using ODBC

Hello,

im using MS Access as a front end to link to MYSQL. although this is
possibly an Access issue i thought someone would be able to help me.
the error message "ODBC--insert on a linked table 'tablname' failed" is
displayed when i attempt to insert records to the MYSQL table.

Does anyone know of a way round this ?? im using the most recent MYSQL
driver and i have only text fields in my insert statement.

any help appreciated.

CG

May 15 '06 #1
2 2187

"csgraham74" <cs********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
Hello,

im using MS Access as a front end to link to MYSQL. although this is
possibly an Access issue i thought someone would be able to help me.
the error message "ODBC--insert on a linked table 'tablname' failed" is
displayed when i attempt to insert records to the MYSQL table.

Does anyone know of a way round this ?? im using the most recent MYSQL
driver and i have only text fields in my insert statement.

any help appreciated.


The error message is, of course, very general and unhelpful.

How was the insert created? Did you use the Access query builder? If so
it's not likely you have a bad SQL statment. Or did you write the "INSERT"
statement yourself? I make mistakes all the time - and I'm an expert ;-)
It would be helpful to post your SQL INSERT statement here.

I'm going to assume that you can double click on the linked table and when
you do, Access brings up the table record view.

A few of the most common problems:

1) The usr/pwd used to set up the linked table ODBC does not have
permission to INSERT/DELETE records. You can view records (SELECT) but you
can not INSERT or DELETE. You may want to try this directly in the Access
table view. You should be able to go to the end of the table and type in a
new record manually.

2) The MySQL table structure has been altered since the link was created
and it needs to be updated/refreshed. Access is confused about the table
structure. A common situation because you can change the table structure in
MySQL and neglect to tell Access about it!

3) You have a malformed SQL statement - not likely if you used the
Access query builder.

There's more but I think that's probably 99%+ of all the problems your
likely to see ;-)
Thomas Bartkus
May 15 '06 #2
thanks for that - im sorry for the lack of information.

Basically i used the Access query builder to build an insert query. Its
a very simple table inserting one automunber field & text/memo fields.
this inserts into a table with integer in MYSQL and varchar. I probably
think the problem relates to ur first suggestion.

I suppose all i have to do is use the root account to test this - il
give it a whirl later.
thanks

again

May 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Frank Pryor | last post: by
20 posts views Thread by Mr Dygi | last post: by
10 posts views Thread by TS | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.