Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver).

In MySQL I created a simple table like this:

CREATE TABLE IF NOT EXISTS `test` (
  `col` int(11) NOT NULL,
  `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`col`)
);

and one example row:

INSERT INTO `test` (`col`, `stamp`) VALUES
(4, '2012-07-17 13:25:29');

When I link the table to Access and update the entry with a query:

UPDATE test SET test.col = 6;

Access will open a dialog asking to confirm the update. But whatever I choose (yes or no) it will update the table anyway. WHY? Does anybody know how to fix this?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.