Sorry Iīve tried it but I didnīt succeed. When writing: update tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have the same value. I donīt know why, but there is the same fault. Iīve created a small database to show my problem. Thatīs my table in MySQL 3.23.41. create table tTest (fTimestamp timestamp(14), fCounter int auto_increment not null, fData1 int, fData2 int, primary key (fCounter)); Itīs connected via ODBC 3.51 with Access 2000. Iīve installed Service Pack 2 and MDAC 2.70. Here is the description of my database. When you enter Frm_Test you will see three buttons. Button Test 1 will insert value 1 in column data 1. (When you insert a different value auto_increment will count correctly but it is necessary for my database to have the possibility to insert the same value.) Button Test 2 will insert value 1 in column data 1 und value 5 in column data 2. Button Delete first record will delete the first record. So -. When you first click several times on Test 1 you will consider that auto_increment counts correctly. But when you now click eg 10 times on Delete first record and then click eg 12 times on Test 1 you will see that Counter will show 10 times the same number and then go on counting correctly. The next problem is that when you click on Test 1 until auto_increment counts correctly and then click on Test 2 you will see that value 5 is inserted correctly in data 2, but when you delete 10 records it will 10 times insert the value in another recordset. Note that you will not see that the counter has the same value, because of the requery. You will see the counter is counting correctly but the value is inserted at another place. The problem is that the record pointer will not point to the current record after refresh but to another random record. I hope this will help you understanding my problem. Regards, Christine Penkert (See attached file: db3.zip)
=?iso-8859-1?Q?db3.zip?=
Description: Zip archive
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
