Via my access2000 mdb i wrote a VB CODE BUT IT SAYS THAT INDEX METHOD IS NOT SUPPORTED VIA ODBC SINCE I LINK VIA ODBC TO MYSQL DATABASE .. MY OLD CODING I AM USING INDEX METHOD .. TO SEEK RECORDS IN JET ENGINGE WHEN A CHANGE TO MYSQL ALL INDEX STATMENTS IS NOT ACCEPTED