Linked table in Access is read-only from MySQL via ODBC

[smercer]

Hi all,

I am having a problem with this linked table(and the only table) in access which is linked to a database in MySQL via ODBC. the problem is that the linked table in access is read-only (I want it to be read and write).

I have searched the internet and found that you need to have the primary key defined, but I have already done that.

This is what I have done: I created the table in access and then exported the table to MySQL. I have then modified the table in MySQL as shown in attachment. I had to redefine the primary key, because Access did not. I then made a link back to access which now works except for it being a read only table.

Operating system: windows 2000
Office version: office 2000
MySQL version: mysql-4.1.7 for windows
ODBC driver version: MyODBC-3.51

I do not know What I have missed, and thought you smart people may be able to help me out.

Thanks very much for any help given.

 

[ders]

I was having a similar problem. When you are linking the table a window pops up with all the fields in your table. It asks you to select up to ten unique fields. the reason I was having your problem was becuase I was not selecting anyting from this list. I am not sure if this is what you are doing when you say that you had to redefine the primary key, because Access did not. Hope this helps.

 

[Tim van Steenbergen]

Access need to know the linked table's primary key. Appearently the table you linked, does not have a primary key. That is why the popup came requesting you to identify the fields of the primary key. If you click away from that popup without selecting any field, you get the read-only mode.
Best regards, Tim van Steenbergen