At 14:18 01/10/2001 -0400, melissa allman wrote: Hi, If you link the MySQL table using MyODBC you can build an Append Query on Access which inform you the number of rows from the record set and at the end the number of rows which had successfully processed. If you want to avoid duplication of records, you need to define a simple or compound primary key in the Access table. Also before to do the Append Query you can build using the Query Wizard of Access for build a query to find duplicate rows.
Regards, Miguel Regards, Miguel >Hi, > >I am working on a project that involves using a form to populate a MYSQL >table. >I then need to transfer these records to an Access database. I want to have a >flag on the MYSQL table to indicate that the record was successfully sent to >Access. >It could be an on/off or Y/N value. I am trying to avoid duplication of >tranfereed records. Has anyone done this? > >Thanks, >Melissa > >------------------------------------------- >The Fastest Browser on Earth. >Get your FREE download of Opera at http://www.opera.com/download/ >------------------------------------------- > > >--------------------------------------------------------------------- >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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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
