Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Browse other questions tagged .