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
add comment

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.