Re: Adding TIMESTAMP Column to MySQL Table

[James Choi]

Hi Martin,

Can you kindly share your wisdom with me on this issue.

I'm a newbie at MySQL and I have MS Access as my FrontEnd.
I've ran into same problem as others have before me on this error of not being able to update data because of write conflict.

As far as I could tell this problem occurs because MySQL is designed to ignore update data when you are trying to update it with same information; hence, you have to create a dummy column with datatype TimeStamp to add when data has been updated or inserted into a table.

Questions that I still have are:

1. How do you add now() as default to TimeStamp Column (I tried typing "now()" in the default field in MySQL Administator GUI App and it did not allow it)

2. Is accessing data recordset using ADO commands best way? or is there an alternative.
Currently I've been using following code to access MySQL to Update a Data

Dim rst as new adob.recordset
Dim cnn as new adob.connection

set cnn = currentproject.connection

rst.open "SELECT * FROM tblCustomer", cnn, adOpenKeyset, adLockOptimistic

rst.Fields!FirstName = "whatever"
rst.update

Any help will be greatly appreciated

Thanks