MS Access linked tables MYSQL

[csgraham74]

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

[Larry Linson]

<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

[chucher]

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

[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