MySQLTalk.org

Ram Rajadhyaksha · Guest

I keep running into this weird problem where pasting lots of records to a
MySQL bound table will show all the items as "#deleted". Closing the table
and re-opening it makes Access update and display the correct values.

However, this is really annoying. I DO have an ID field of type INT that is
a primary key and a TIMESTAMP field of type TIMESTAMP(14).

Also, does anyone know how to properly emulate the "Yes/No" type in Access?
I tried making an INT in my MySQL table and then changing the table
definition in Access to Yes/No, but whenever something is "Yes", Access
puts a -1 value in the record.

Regards,

--Ram

--
* Ram Rajadhyaksha "There is nothing more conducive to panic *
* Inflection Technology Corp. than a no choice situation." - J. Jillson *
* <URL:mailto:ramr (AT) best (DOT) com> <URL:http://www.inflectioncorp.com/ramr/> *