469,282 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

MS Access linked tables MYSQL

Hi Folks,

im using MS Access as a front end to link to MYSQL. although this is
possibly a MYSQL 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. Is there an
Access setting or permission that i must change

thanks in advance

CG

May 15 '06 #1
3 3064

<cs********@gmail.com> wrote in message
news:11*********************@v46g2000cwv.googlegro ups.com...
Hi Folks,

im using MS Access as a front end to link to MYSQL. although this is
possibly a MYSQL 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. Is there an
Access setting or permission that i must change


Some server DBs require that you have a Primary Key defined on each Table
that you update -- I don't know if that is the case with MySQL. That should
be a quick thing to check.

Larry Linson
Microsoft Access MVP
May 15 '06 #2
You may be using a constraint in one of your fields (maybe a
relationship between two tables). When you are inserting data into the
table you aren't inserting it into the field with the constraint

May 16 '06 #3
Bri
cs********@gmail.com wrote:
Hi Folks,

im using MS Access as a front end to link to MYSQL. although this is
possibly a MYSQL 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. Is there an
Access setting or permission that i must change


As Larry mentioned, you need to have a Primary Key defined in the Table.
If you don't have one, add in a new field of type INTEGER and set the
AUTO_INC. Make this your PK. You also need to create a TimeStamp field
(with a default value of CURRENT_TIMESTAMP) if you plan to edit the
records later (needed to control record locking).

--
Bri

May 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Thomas Bartkus | last post: by
17 posts views Thread by chicha | last post: by
10 posts views Thread by Mike | last post: by
1 post views Thread by gordon.dtr | last post: by
4 posts views Thread by Vanessa | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.