Skip navigation links

MySQL Forums :: Microsoft Access :: Write conflict with Access as frontend and MySQL as backend


Advanced Search

Write conflict with Access as frontend and MySQL as backend
Posted by: Scott Mercer ()
Date: January 06, 2005 11:29PM

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!!

Options: ReplyQuote


Subject Views Written By Posted
Write conflict with Access as frontend and MySQL as backend 12103 Scott Mercer 01/06/2005 11:29PM
Re: Write conflict with Access as frontend and MySQL as backend 5977 Scott Mercer 01/10/2005 08:40PM
Re: Write conflict with Access as frontend and MySQL as backend 6493 Anne Abbott 08/04/2005 04:50AM
Re: Write conflict with Access as frontend and MySQL as backend 5684 ampm 08/30/2005 11:46AM
Re: Write conflict with Access as frontend and MySQL as backend 4932 Ratnesh Mathur 06/06/2008 06:07AM
Re: Write conflict with Access as frontend and MySQL as backend 5245 Federico valori 02/17/2005 05:52AM
Re: Write conflict with Access as frontend and MySQL as backend 5225 Tony Brooke 09/11/2005 10:52AM
Re: Write conflict with Access as frontend and MySQL as backend 5135 Rajeev Vasu 03/19/2008 08:39AM
Re: Write conflict with Access as frontend and MySQL as backend 7837 Mathias van Gemmern 05/28/2008 10:51AM
Re: Write conflict with Access as frontend and MySQL as backend 5068 Alan Parker 10/22/2008 07:43AM
Re: Write conflict with Access as frontend and MySQL as backend 3852 Eric Litwin 03/04/2009 04:51PM
Re: Write conflict with Access as frontend and MySQL as backend 3805 May Bac 04/09/2009 03:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.