Write conflict with Access as frontend and MySQL as backend

[Scott Mercer]

Hi all,

I am having problems with the linked table in Access where the records will not update when I leave the record after I have edited a record.

Here is what I have done:
in "configure/ODBC - Configure data source name" dialog box -> advanced tab
Return Matching Rows: true

+---------------------+------------------+------+-----+---------+---------------
-+
| Field | Type | Null | Key | Default | Extra
|
+---------------------+------------------+------+-----+---------+---------------
-+
| Event_Number | int(10) unsigned | | PRI | NULL | auto_increment
|
| Event_Heading | varchar(50) | YES | | NULL |
|
| Location | varchar(50) | YES | | NULL |
|
| Event_Time | datetime | YES | | NULL |
|
| Event_Description | text | YES | | NULL |
|
| After_event_Descrip | text | YES | | NULL |
|
+---------------------+------------------+------+-----+---------+---------------

I had just taken out a column called Event_Date with type timestamp and it <b>was</b> working for the other fields except for Event_Time and Event_Date. I wanted to take out unnecessary columns and now all fields are doing it (before it was only the two date/time fields).

Thanks in advance for the help!!