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

MS Access linked tables MYSQL

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a

<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

P: n/a
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

P: n/a
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.