Good point, Cy, the Upsize wizard will also refuse to handle an index on Deleted(), although it just skips it and continues with the upsizing.

>And a caviat recently found. If you have index tags on deleted() on your tables, Access has trouble dealing with the tables (sometimes). We have such a tag on EVERY table in our product, and access has a problem with about 1 table in 7. Go figure, you would think it would have a problem all the time, or never, but not Access. Just part of the time. I have also seen some benchmarks in either Foxpro Advisor or Foxtalk (can't remember which right now) that imply that having a tag on deleted() may actually slow queries down unless you have a LOT of deleted records in your data all the time.