MySQL Forums
Forum List  »  Microsoft Access

Re: Write conflict with Access as frontend and MySQL as backend
Posted by: Alan Parker
Date: October 22, 2008 07:43AM

Add a field to table of type datetime default null

Update link in access

write and run update query to populate this field with now()

Then change this field to type timestamp and default value current_timestamp.

Relink in access.

Job done..

The key to this is that the field is populated... for the timestamp to work.

Options: ReplyQuote




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.