I try to connect to MySQL database throw ODBC . All i Ok except ... when i'am trying to add new record in the form of access (linked) table i got that record is deleted immidiatly after i hit Enter ... All begins when i try to set one of fields as AUTO_INCREMENT and UNIQUE : ALTER TABLE upd DROP INDEX upd_id; ALTER TABLE upd MODIFY upd_id MEDIUMINT; ALTER IGNORE TABLE upd ADD UNIQUE upd_id(upd_id); When i have no indexed field - all was all-right but i want to add new records to MySQL database , and not to see on value of index field - last one must be AUTO incremented when i do this ! Can your tell me is this problem of MyODBC of of microSOft_DeVeLoPmEnTs. How can your help me to do this ... or there is no way to work this way with MySQL. PS.I use ACCESS 2000 & latest MyODBC. --------------------------------------------------------------------- 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