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

re: MS Access linked tables MYSQL

<csgraham74@gmail.com> wrote in message
news:1147726709.116174.41660@v46g2000cwv.googlegro ups.com...[color=blue]
> 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[/color]

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

re: MS Access linked tables MYSQL

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

re: MS Access linked tables MYSQL

csgraham74@gmail.com wrote:[color=blue]
> 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[/color]

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