Hi,
Iīve already tried using MyODBC 3.51.02 by enabling Dynamic Cursor, it didnīt help. Now Iīve sent a mail to the access newsgroup. I hope it will help. Many thanks for your help. Regards, Christine Hi !! I did looked into you issue and could able to see the behaviour whatver you described. But the thing is that, the data is inserted correctly and retrieved correctly from the datbase, and the issue lies in Access in displaying it. You can see the behaviour by using Apply filter or remove filter. Can you please post this to Access news groups saying your data is not correctly displayed. I tried to search the Access KB for the related issues, but couldn't catch it. Did you tried by using MyODBC 3.51.02 by enabling Dynamic cursor type, for any luck ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > -----Original Message----- > From: Penkert, Christine [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:19 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Re: Problem with MySQL, ODBC, MS Access > > > > > Hi, > > Can anyone help me please? Iīm writing my diploma and this database is my > project. Iīm running out of time and when this problem doesnīt > disappear... > Please help me. > > 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) > --------------------------------------------------------------------- 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
