Drop Index Corrupts Data

From: Neil Kerkin (nkerkin_at_gmail.com)
Date: 09/30/04 

Date: 29 Sep 2004 20:07:07 -0700

Hi all,
VB6 Program, ADO 2.5, Access97 Database

con.Execute "DROP INDEX URNO ON tblPatients"

tblPatients has 15000 records
URNO is not the Primary Key (just an index on URNO (text 12) field
ascending)

Query executes without error however when the table is opened in
access *some* (66) of the records have gone crazy, ie URNO has changed
from 178193Q004 to þç•, 495902Q004 to "ÿG¡à3. There is no
discernable difference between the records that get corrupted and the
ones that don't change.

I have used the same method to drop other indices (including primary
keys) on this and other tables and have seen no other corruption
whatsoever. Also, running the query in access does not corrupt the
fields.

Any help would be greatly appreciated.
Thanks

Neil kerkin